Daily Archives: June 30, 2010

PASS, Don’t Waste My Time

Update: Apparently I can’t write, or get a point across from the comments and a few emails, so I have edited this to hopefully make it clearer. The pre/post conference sessions came out today for the 2010 SQL PASS Summit. … Continue reading

Posted in Blog | Tagged , | 16 Comments

Truncating the Log and Database Mirroring

I saw someone post recently that they wanted to run this code on their principal server in database mirroring to clean out a large transaction log and shrink it. alter database <mydb> set recovery simplegocheckpointgoalter database <mydb> set recovery fullgobackup … Continue reading

Posted in Blog | Tagged , , | Comments Off on Truncating the Log and Database Mirroring