Moving System DB’s – Part 2

I was recently approached by my manager to free up a Direct Attached Storage (DAS) device from a test server so that it could be leveraged in a higher environment. To my amazement, both the system databases and binary executables were installed on the drive I needed to move. Today, we are going to concentrate on moving master and resource system databases. Here is a article from MSDN to use as reference. Moving the master database 1 – Open the SQL Server configuration manager. 2 – Select the SQL Server…

Moving System DB’s – Part 1

I was recently approached by my manager to free up a Direct Attached Storage Device (DAS) from a test server so that it could be leveraged in a higher environment. To my amazement, both the system databases and binary executables were installed on the drives I needed to move. From the lessons I learnt over the past few days, I am going to write a series of articles on moving a SQL Server system. Please refer to my database files article which explains how to move user databases. Today, we…