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 |
|
mary_itohan
Posting Yak Master
191 Posts |
 Posted - 2006-10-23 : 00:31:40
|
| hello All,I have a backkup file from my old database and want to create a new database and restore the backkup file to it ?1. Must i name the new database with the same name as the old database ?2. I tried giving it a new name, ie old server was "project_a" and the new database was "princess" and tried a restore, but it declined.3. Does anyone have any pointers to documentation on how this is done ?Any advice on the above please ? How do i get the backup file project_a.bak to the new server and what name do i give it, documentations will be appreciated.thank youMaryYes O ! |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-23 : 10:27:34
|
quote:
1. Must i name the new database with the same name as the old database ?
No - a new name is fine quote:
2. I tried giving it a new name, ie old server was "project_a" and the new database was "princess" and tried a restore, but it declined.
You'll have to be more specific quote:
3. Does anyone have any pointers to documentation on how this is done ?
The RESTORE command and the topic "Backing Up and Restoring Databases" in Books Online. quote:
How do i get the backup file project_a.bak to the new server and what name do i give it, documentations will be appreciated.
Just copy the file over there and then use the RESTORE command or Enterprise Manager (right-click Databases, select All Tasks/Restore Database...) to restore. |
 |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Migrating databases