Check for database files not in default location
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 […]