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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-11-11 : 07:28:27
|
| jim writes "we have 2 servers, 1 production, 1 backup. we would like to backup the production databases and restore them on the backup server. what implications or concerns should I have with the backup database being restored on a server that it didn't "growup" on?" |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-11 : 09:13:35
|
| Hi jim, Welcome to SQL Team!If you are restoring to a database with a different name (on the target server) you may need to fiddle with the logical names (as you make the restore)Having restored you will need to synchronise the IDs for the Database Users to the Server Logins [i.e. the ones stored in master]; and to achieve this new users that are added to the "source" Server will also need to be added to the "target" server (they can be scripted so that the task is automated)Would Log Shipping suit you better? (i.e. is the Backup server a "warm standby"? If you have the Enterprise version of SQL Server it has a Wizard for "Log Shipping" built in, if not there are scripts around to achieve this without too much effort.Kristen |
 |
|
|
|
|
|
backup