Webboy2008
asked on
sql backup
I have .bak file from sql server 2005, and now I want restore the .bak to sql server 2008
in other box.
How can I do that in SQL studio?
in other box.
How can I do that in SQL studio?
Save your backup file to the destination server
In SSMS, right click on Databases then select Restore Database
You will get a dialog as shown here
Type in the name of the database
Check From Device and use the button to locate your backup file
Click OK and the file should be restored to the new server
RestoreDB.png
In addition you may have to change the paths to the database files.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
that's about it