Database Administrator Passionate About Automation, Performance and Security
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
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
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
Chad Franklin 