Recently for one of our customers we had to perform a DR drill activity. To give a background on the environment, they were using SQL 2000 Database as a backend of SAP Application and the SQL Database was log shipped to Remote DR server. We had also customized the Log Shipping to add compression/decompression logic… Continue reading Steps to Failover and Failback a Log Shipping Database in SQL 2000