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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2003-05-08 : 07:10:52
|
| Hello ,We are planning to simulate a Disaster Recovery for our production SQL servers . How can we map the databases , the users , their passwords , all SP's and views almost the exact structure of the current databases to DR Server . So when the DR site come up all the users will be mapped to the DR SQL Server . My thought process was to copy the bak files to DR server and restore it on that server itself and execute a login transfer DTS task to the DR server . Just came across Log shipping concept where exact replication of the database can be done . Can Log shipping help us so that we don't have change the ODBC settings on the users side . They will automatically map to the DR server . Is this true ? Would like to know 1. What is the difference between Logshipping and Replication ?2. Will Log Shipping be useful to us in this DR case . 3. Will the planned login transfer task also transfers the passwords ? If not then in what way can I transfer the paswds to the DR ? Need some help and info. in this regard . Thank you . |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-08 : 11:46:08
|
| Log Shipping is meant for High Availability, Replication is not. Replication is meant for the dispursment of data to remote locations, and was never meant for High Availability or disaster recovery. Neither is really meant for disaster recovery. Disaster recovery is your Backup Plan, and keeping tapes offsite etc...In log shipping you start with a full backup of your db, so all of your users are there, you will need to transfer the logins which can be done through DTS. You will also need to map each user back to it's login, which can be done via a script you can find in the "Scripts" forum called "Fix orphaned users" or something like that.There is no (Current) way that I know of to "Automatically" redirect users to a log shipped DB, I would think you still have to change the Settings on the User's machine.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2003-05-08 : 22:46:01
|
| Thanks Chad , for the valuable information .Regds |
|
|
|
|
|
|
|
|
Log Shipping Vs Replication.