Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Msg 5133, Level 16, State 1, Line 2
- Directory lookup for the file "D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATADb.mdf" failed with the operating system error 21(failed to retrieve text for this error. Reason: 15105).
- Msg 3156, Level 16, State 3, Line 2
- File 'Db' cannot be restored to 'D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATADb.mdf'. Use WITH MOVE to identify a valid location for the file.
- Msg 5133, Level 16, State 1, Line 2
- Directory lookup for the file "D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATADb_log.LDF" failed with the operating system error 21(failed to retrieve text for this error. Reason: 15105).
- Msg 3156, Level 16, State 3, Line 2
- File 'DbDev_log' cannot be restored to 'D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATADb_log.LDF'. Use WITH MOVE to identify a valid location for the file.
- Msg 3634, Level 16, State 1, Line 2
- The operating system returned the error '21(failed to retrieve text for this error. Reason: 15105)' while attempting 'GetVolumeInformation' on 'D:'.
- Msg 3013, Level 16, State 1, Line 2
- RESTORE DATABASE is terminating abnormally.
- LogicalName PhysicalName Type FileGroupName Size MaxSize FileId CreateLSN DropLSN UniqueId ReadOnlyLSN ReadWriteLSN BackupSizeInBytes SourceBlockSize FileGroupId LogGroupGUID DifferentialBaseLSN DifferentialBaseGUID IsReadOnly IsPresent TDEThumbprint
- Db D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATADb.mdf D PRIMARY 29622272 35184372080640 1 0 0 02925462-83CC-4222-8966-53229FA25B1C 0 0 29032448 512 1 NULL 269000000146900238 735C7F0E-F63D-4AA1-AC48-505A084AC00B 0 1 NULL
- Db_log D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATADb_log.LDF L NULL 40239104 2199023255552 2 0 0 71038B04-CBC9-4E4A-93AD-4E1268859CB2 0 0 0 512 0 NULL 0 00000000-0000-0000-0000-000000000000 0 1 NULL
- DbDev_filestream D:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATADb S PRIMARY_FILESTREAM 4691012 0 65537 18000000011800001 0 627C9AAA-97BD-4991-9C8C-90C400226A9F 0 0 4784128 512 2 NULL 269000000146900238 735C7F0E-F63D-4AA1-AC48-505A084AC00B 0 1 NULL
- Use WITH MOVE to identify a valid location for the file.
- USE [master]
- RESTORE DATABASE [AdventureWorks2008R2]
- FROM DISK = N'C:SQL BackupsAdventureWorks2008R2.bak'
- WITH FILE = 1,
- MOVE N'AdventureWorks2008R2_Data' TO N'C:MyNewDataLocationAdventureWorks2008R2_Data.mdf',
- MOVE N'AdventureWorks2008R2_Log' TO N'C:MyNewLogLocationAdventureWorks2008R2_Log.ldf',
- MOVE N'FileStreamDocuments2008R2' TO N'C:MyNewFileStreamLocationDocuments2008R2',
- NOUNLOAD, REPLACE, STATS = 1
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement