Comments
Sort by recent activity
Hello, you can use the Restore command using the MOVE option USE [master]
RESTORE DATABASE [AdventureWorks2008R2]
FROM DISK = N'C:\SQL Backups\AdventureWorks2008R2.bak'
WITH FILE = 1,
MOVE N'AdventureWorks2008R2_Data' TO
N'C:\MyNewDataLocation\AdventureWorks2008R2_Data.mdf',
MOVE N'AdventureWorks2008R2_Log' TO
N'C:\MyNewLogLocation\AdventureWorks2008R2_Log.ldf',
MOVE N'FileStreamDocuments2008R2' TO
N'C:\MyNewFileStreamLocation\Documents2008R2',
NOUNLOAD, REPLACE, STATS = 1
GO I hope this will help you. / comments
Hello, you can use the Restore command using the MOVE optionUSE [master]
RESTORE DATABASE [AdventureWorks2008R2]
FROM DISK = N'C:\SQL Backups\AdventureWorks2008R2.bak'
WITH FILE = 1,
MOVE ...
If you still have the same problem, your backup may be corrupted. You can take the help of a third-party tool like SysTools SQL Backup Recovery Software. This application will allow you to repair corrupted SQL backup file and directly export all data to the live SQL Server database. / comments
If you still have the same problem, your backup may be corrupted. You can take the help of a third-party tool like SysTools SQL Backup Recovery Software. This application will allow you to repair c...