Wednesday, April 20, 2011

Transaction Log Shipment

Firstly step by step process to setup TLS
http://omaralzabir.com/how_to_setup_sql_server_2005_transaction_log_ship_on_large_database_that_really_works/
I also realized that the restore opertation is faster when done using the norecovery option (recovery option rollsback uncommitted transactions and returns the database to a consistent state hence takes additional time) so the trick to save time when applying multiple transactions logs is to restore each log with norecovery and after the last log is recovered put the database to the standby mode using a command as follows

RESTORE DATABASE mydatabase WITH STANDBY = 'C:\mydatabase_undo.dat'