May 19, 2013 at 8:25 pm
Is it safe to move the system databases (excl TEMPDB in this question) to another location from the default install location.
This being done either during the initial install or during an outage?
I can remember getting burnt a few years ago on SQL 2000 when an HotFix kept on failing because it was looking for the System databases to be in a certain location (default) and I had moved them.
This was a while ago and may have been a one off and / or not applicable now.
thanks
May 20, 2013 at 1:04 am
Yes it is supported.
Check the link for details.
May 20, 2013 at 6:18 am
It is supported, but as a guy called Paul once said 'All things are possible, but not all things are advisable'.
There are no data integrity or performance reasons for moving master, model or the Resource DB. All you do is risk causing a problem that can give you downtime. As you said, Microsoft has a poor record of issueing fixes that assume these databases are in the default locations.
You have to decide if moving these databases is right for you, and if you do move them you have accept the consequences if something breaks either today or in 2 years time. Personally, I would leave them in the default locations.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
May 20, 2013 at 6:31 am
EdVassie (5/20/2013)
It is supported, but as a guy called Paul once said 'All things are possible, but not all things are advisable'.There are no data integrity or performance reasons for moving master, model or the Resource DB. All you do is risk causing a problem that can give you downtime. As you said, Microsoft has a poor record of issueing fixes that assume these databases are in the default locations.
You have to decide if moving these databases is right for you, and if you do move them you have accept the consequences if something breaks either today or in 2 years time. Personally, I would leave them in the default locations.
+1
Nowadays if you specify a new location as part of the install you should be ok, but having installed leave the system dbs where they are unless you have a very good reason to move them.
normal exclusions for tempdb.
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply