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 - 2003-09-23 : 08:04:47
|
| Anil writes "We are planing Disaster Recovery of large Database loacted in delhi to a remote location say Hyderabad.Steps of SQL DR Implementation:-------------------------------Step 1: Take Backup of database Step 2: Restore backup database Locally on the DR Machine (to be sent to Hyderabad)Step 3: Send the m/c to HyderabadStep 4: copy the transaction Log from source database m/c to DR m/c every 6 hours.After making exact copy of databse on DR m/c Once in the begining. Thereafter By scheduling Copying and applying of Transaction Logs to the destination DR m/c can the database on the DR m/c be exactly identical to database source m/c" |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-09-23 : 09:01:09
|
| Check BOL on topic 'Disaster Recovery Plan'.Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-09-23 : 21:37:01
|
| Yes - up to the tr log backup.But if you can't send a complete backup then you will need to make sure that the tr log can be applied before allowing the log top truncate on the source m/c.Think about differentials too.There were problems with restoring a standby m/c from a backup - don't know if that's still the case but you should keep all the tr logs sent just in case and be prepared for a long task for recovery.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
SQL Transaction Log