July 30, 2013 at 4:50 pm
SQL Server 2005;
Was wondering if I can point the system databases to another set of system database files. Such as I have a set start up is pointing to on D:\ and I want them to point to a set on F:\. Is this possible and how or what steps should I take. If get them pointing to the F:\ I can delete the files on D:\. Any other info needed let me know.
July 30, 2013 at 6:36 pm
You can move the files of system databases but - depending on which database - a special procedure is needed. Have a look here: http://msdn.microsoft.com/en-us/library/ms345408%28v=sql.90%29.aspx
July 30, 2013 at 9:13 pm
do you currently have copies of your system databases in multiple locations?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 31, 2013 at 8:38 am
Yes, The systems guy attached the drive from the previous server. When I installed I put the system databases on d: but the were already on F:/. I was able to attach the user databases, but wanted to know an easy way to tie the system databases from the f: without scaping everything and just restoring.
July 31, 2013 at 11:03 am
the previous doc mentioned should help you get the databases moved.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 6, 2013 at 9:23 am
What you want to do is a bit like cutting open your chest and connecting your major blood vessels to another heart. It can work, but do not be surprised if you get a bit of leakage.
To increase your chances of success, make sure the databases you want to connect to and the new SQL install are at the same fix level.
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
August 6, 2013 at 9:25 am
Just realised you were doing this on SQL 2005. Be aware that the SQL 2005 SPs and CUs have a poor record of being able to work if master and the resource database are not in their default locations.
I have had situations where I have to move the system databases back to the default locations in order to get a patch applied. It is now considered best practice to never move these databases from their default locations, regardless of SQL Server version.
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply