Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
learning_grsql
Posting Yak Master
230 Posts |
Posted - 2013-07-22 : 16:29:05
|
I have a .bak full database backup from a computer. Now I installed new SQL Server 2005 in another computer and would like to restore the .bak database here. How it can be done?When I right click database and select restore database, it opens a window where it asks to put "destination for restore". This is a new SQL Server, how can I restore then? |
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2013-07-22 : 16:54:08
|
http://www.tech-recipes.com/rx/2081/sql_server_2005_how_to_restore_database_backup/ |
|
|
learning_grsql
Posting Yak Master
230 Posts |
Posted - 2013-07-23 : 02:37:55
|
Thanks Lamprey. However, it seems you did not get my point. In my case, there is nothing to select for "To" (destination) because this is a newly installed SQL Server in another computer. |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2013-07-23 : 10:44:01
|
If I understand you correctly there are two options:1. Create a database and restore to it.or1. Right-click on the Databases node on SSMS object explorer and select Restore Database...2. In the the Source section select Device and then use the "picker" to browse to your BAK file ans select it.3. In the Source section the Database drop-down list it should show the name of the database you backed up, assuming there is only one DB in the backup set.4. In the Destination section a database name should appear in the Database editable drop-down list. If you want to change the name you can, and it will create the database with the name in that list-field. |
|
|
|
|
|