Maintenance

How to Move TempDB to a different Drive or Folder

Sometimes you'll need to move the TempDB files to a different drive or folder. It's a pretty simple operation and I'll provide a script for you to use. Typically to move the TempDB files, you would do it in 3 stages: Set the new location in SQL Server, by running a command in SSMSRestart SQL… Continue reading How to Move TempDB to a different Drive or Folder

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

SSRS

Installing Multiple SSRS Instances on a Server is a Thing of the Past

Recently I ran into an unexpected problem where I tried to install multiple instances of SQL Server Reporting Services (SSRS) on one server. After installing the first SSRS instance successfully, I attempted to install the second instance. Only, I couldn't see where or how to install the second instance. It turns out, since SSRS 2017,… Continue reading Installing Multiple SSRS Instances on a Server is a Thing of the Past

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