• I really like the way you demonstrated the difference in times in the restore process. I'm sure smeone will point out that you can skip zeroing out the log file too (or even the data file) by using replace to replace an existing database with a log file at least that same size. That's a tangential point and out of scope for your article, so I think it's fine that you didn't include that point.

    One small correction: it's secpol.msc, not exe.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]