January 2012
1 post
Cleaning up SQL Server 2008 Simple Databases
We make lots of databases here at the office. Often they’re play databases, or restore databases, or test databases. Since they rarely progress from development status to production status, they need to be set up with simple recovery model so they don’t collapse under the weight of the dozens of gigabytes of transaction logs my programmers pump in every day (at least, until Western...