Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2014
169
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.72 KB | None | 0 0
  1. Msg 5133, Level 16, State 1, Line 2
  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).
  3. Msg 3156, Level 16, State 3, Line 2
  4. 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.
  5. Msg 5133, Level 16, State 1, Line 2
  6. 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).
  7. Msg 3156, Level 16, State 3, Line 2
  8. 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.
  9. Msg 3634, Level 16, State 1, Line 2
  10. The operating system returned the error '21(failed to retrieve text for this error. Reason: 15105)' while attempting 'GetVolumeInformation' on 'D:'.
  11. Msg 3013, Level 16, State 1, Line 2
  12. RESTORE DATABASE is terminating abnormally.
  13.  
  14. LogicalName PhysicalName Type FileGroupName Size MaxSize FileId CreateLSN DropLSN UniqueId ReadOnlyLSN ReadWriteLSN BackupSizeInBytes SourceBlockSize FileGroupId LogGroupGUID DifferentialBaseLSN DifferentialBaseGUID IsReadOnly IsPresent TDEThumbprint
  15. 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
  16. 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
  17. 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
  18.  
  19. Use WITH MOVE to identify a valid location for the file.
  20.  
  21. USE [master]
  22. RESTORE DATABASE [AdventureWorks2008R2]
  23. FROM DISK = N'C:SQL BackupsAdventureWorks2008R2.bak'
  24. WITH FILE = 1,
  25. MOVE N'AdventureWorks2008R2_Data' TO N'C:MyNewDataLocationAdventureWorks2008R2_Data.mdf',
  26. MOVE N'AdventureWorks2008R2_Log' TO N'C:MyNewLogLocationAdventureWorks2008R2_Log.ldf',
  27. MOVE N'FileStreamDocuments2008R2' TO N'C:MyNewFileStreamLocationDocuments2008R2',
  28. NOUNLOAD, REPLACE, STATS = 1
  29. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement