How to Move System Databases to a New Physical Directory

Question

How to Move System Databases to a New Physical Directory

Kim Killian-SiteDataView

Ten Centuries

Points: 1309
More actions
May 25, 2020 at 12:00 am

#3751337

Comments posted to this topic are about the item How to Move System Databases to a New Physical Directory
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

pietlinden SSC Guru Points: 63502 More actions · Answer 1

Something I should practice... for sure!

I have to admit that my very first response to the question was "Can I do this with the dbatools PowerShell library?" I should have a look at that too... especially since if you're moving system databases around, you're probably doing a bunch of other stuff that's just begging to be automated.

rchantler SSCrazy Points: 2128 More actions · Answer 2

Isn't there a hidden system database you also need to take care of?

Kim Killian-SiteDataView Ten Centuries Points: 1309 More actions · Answer 3

No there are not.

Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook

rchantler SSCrazy Points: 2128 More actions · Answer 4

Isn't there a hidden system database named references?

rchantler SSCrazy Points: 2128 More actions · Answer 5

Sorry, not reference but 'resource' database. Hidden system database introduced in SQL Server 2005.

Sue_H SSC Guru Points: 90860 More actions · Answer 6

rchantler wrote:

Sorry, not reference but 'resource' database. Hidden system database introduced in SQL Server 2005.

Good thought as people often overlook the resource database. It's not a database to move though. It needs to be in the default location in the MSSQL\Binn directory. It was a little different on SQL Server 2005 where you could move it but it needed to be in the directory with the master data file. They do mention in the current documentation that it shouldn't be moved:

Resource Database

Sue

Kim Killian-SiteDataView Ten Centuries Points: 1309 More actions · Answer 7

No it is not necessary to move that one.

Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook

RichB Newbie Points: 1 More actions · Answer 8

Hi,

Registered so I could thank you! Not a DBA but had to recover a database after a major hardware failure, this guide was followed to the letter & a critical system was moved from barely working storage to shiny flash storage.

Thank you.

pparnofi Newbie Points: 2 More actions · Answer 9

Can't thank you enough! My job was a Covid casualty - unemployed for just over a year. Been playing with SQL Express - this REALLY helped to knock off some cobwebs.

Much appreciated!

Paul

gh Newbie Points: 3 More actions · Answer 10

Thanks for this.

I think there's a missing piece in the move the master DB part.

I don't see the part where you actually physically move the mdf and ldf for master.

regards

sam_jajal SSC Rookie Points: 34 More actions · Answer 11

What is the reason we have to update the registry?