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