Check for database files not in default location

April 21, 2015 at 20:50

This week I discovered a database with its files not placed in the default folder (it was in fact installed in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ :(). It turned out the creation of this database was done using a script provided by the manufacturer, ignoring the default file location settings. I […]

SQL Server error 17310

April 14, 2015 at 20:33

The problem Recently I had to migrate a SQL2005 database to a SQL2008R2 instance. So I picked up a copy of the database and restored in onto a test server. After restoring the database I changed a few settings (change compatibility mode, set page verify to checksum, changed recovery model) […]

Trace flags in SQL Server

April 3, 2015 at 15:56

Trace flags in SQL Server allow you to change the behaviour of parts of SQL Server. Most information about trace flags can be found in several KB articles but usually this information does not provide too much detail.