Transaction Log Shipping\Applying
Posted on 2009-05-20
We recently installed SQL Server 2005 ( call it Server A) and created few databases on it. We would like to setup a DR server in a remote location for these databases. The plan is to,
1) Create another SQL Server 2005 (server B) in the remote location.
2) take a backup of the databases from A, restore them on B
3) After that backup and ship the transaction logs for each database from server A to server B every night.
Being new to all this , what i am looking for is detailed STEPS/Screen shots , suggestion in achieving Step 3.