General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Restoring a Database to New Location
I successfully backed up a database from a SQL server on the network and want to restore that backup to my local SQL Server from the backup called c:\mssql7\backup\backup.bak. When attempting to restore the database OVER my local database I get the following error: [ The file d:\msssql7\data\dbpdr_data.mdf cannot be used by RESTORE. Consider using the WITH MOVE option to identify a valid location for the file. Backup or restore operation terminating abnormally. I am doing all this through the SEM. I use the From Device option then I point to a Backup.bak file for the restore. I've read help on RESTORE, but don't quite see where I can tell the file name location.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only