Browse by Tags

11 June 2010
Upgrading log shipping from 2005 to 2008 or 2008R2

If you're using log shipping you need to be aware of some small print. The general idea is to upgrade the secondary server first and then the primary server because you can continue to log ship from 2005 to 2008R2. But this won't work if you're keeping your secondary databases in STANDBY... Read More...

no comments

Filed under: SQL Server 2005, Log Shipping, SQL Server 2008, SQL Server 2008 R2

04 March 2010
Log shipping and shrinking transaction logs

I just solved a problem that had me worried for a bit. I'm log shipping from three primary servers to a single secondary server, and the transaction log disk on the secondary server was getting very full. I established that several primary databases had unused space that resulted from big, one-off... Read More...

2 comment(s)

Filed under: SQL Server 2005, Log Shipping

05 July 2009
Roll your own log shipping

I tried to use SQL Server’s built-in log shipping to set up a disaster recovery facility but I found there were some serious limitations. So, after some research, I decided to do it myself. Here’s what happened. Requirements A disaster recovery plan is useless unless you can test it, preferably at least... Read More...

5 comment(s)

Filed under: Log Shipping