I am trying to restore a DB
I am getting this prompt, however I am unable to point to a database to restore from
Has anyone else experienced this horrific problem?
+3
A:
Assuming you backed up a database to a file, click the From device radio button and follow the instructions.
OMG Ponies
2010-07-13 20:25:14
i tried this and i pointed to the file but it gave me access denied
I__
2010-07-13 20:35:15
@|__: File permissions issues you have to deal with...
OMG Ponies
2010-07-13 20:42:48
@|__: if you want to restore a file, that file has to be on that server machine - you cannot restore to a remote server if the file is on your local machine. Could that be the problem by any chance??
marc_s
2010-07-13 20:46:20
+1
A:
This is not right. You need to read the article OMG Ponies posted earlier: http://stackoverflow.com/questions/3240978/sql-server-how-do-i-export-entire-database. You need to select "From Device", then from file and browse from the backup file you created". You sound like a noob, so be careful when handling this database.
icemanind
2010-07-13 20:25:29
Doing what you are trying to do should be a 3 step process:1. Create your backup file2. Move the backup file to your new server (to a location that you have file access to)3. Restore from the backup fileThat's it!
icemanind
2010-07-13 20:52:18
+3
A:
One thing that might bite you in the backend is the fact that the SQL Server backup will contain the path where it wants to be restored to (the original paths).
If you select your backup file, make sure to select the checkbox in the Restore column, and then click on the Options page on the left:
Once you do, you should see the path where SQL Server wants to restore the data and log files to - you might need to adapt that to your own situation on your machine:
marc_s
2010-07-13 20:55:34