SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 restore database backup to a new server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

learning_grsql
Posting Yak Master

230 Posts

Posted - 07/22/2013 :  16:29:05  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

4614 Posts

Posted - 07/22/2013 :  16:54:08  Show Profile  Reply with Quote
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 - 07/23/2013 :  02:37:55  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

4614 Posts

Posted - 07/23/2013 :  10:44:01  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000