Maintenance

Detaching then Attaching a Database Loses the Database Settings

In my last post about moving database files, I touched on the point when you detach and then attach a database, you lose some of the database settings. This is a real gotcha that many people don't realise...until they've done it and wonder why things become broken. The database settings that get changed when you… Continue reading Detaching then Attaching a Database Loses the Database Settings

Maintenance

Moving Database Files, It Ain’t That Hard

From time to time, the database data files (like *.mdf and *.ndf), or transaction log files (like *.ldf) need to be moved or renamed, in some way or another. Sometimes, to a different drive or volume. Sometimes, to a different folder on the same drive. Sometimes, the files need to be renamed too. For some… Continue reading Moving Database Files, It Ain’t That Hard

Monitoring

How to Find Out the Progress of Maintenance Tasks

You kick off a few maintenance tasks on your SQL Server instance, or they they were scheduled to start via a job which may be slowing your server down. For example a full backup, or a DBCC CHECKDB, or maybe even shrinking a file. You might be getting a touch nervous of the potential impact… Continue reading How to Find Out the Progress of Maintenance Tasks