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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 restore database backup to a new server

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/
Go to Top of Page

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.
Go to Top of Page

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.

or

1. 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.
Go to Top of Page
   

- Advertisement -