SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Change SQL Data Root Directory


Change SQL Data Root Directory

Author
Message
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)

Group: General Forum Members
Points: 56013 Visits: 17729
Placing system dbs on C is not too dramatic as the boot drive it will always be online while the server is up. Obviously tempdb and distribution db should be separated.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
lmacdonald
lmacdonald
SSC Eights!
SSC Eights! (974 reputation)SSC Eights! (974 reputation)SSC Eights! (974 reputation)SSC Eights! (974 reputation)SSC Eights! (974 reputation)SSC Eights! (974 reputation)SSC Eights! (974 reputation)SSC Eights! (974 reputation)

Group: General Forum Members
Points: 974 Visits: 564
Well I may have just caught a break. Thanks for your quick responses guys but there probably isn't a point in copying and pasting all the errors now. I was told that only a couple servers need to have their system databases moved, and none of them actually host any data yet. They are all brand new installs, so far it's been quicker and cleaner to just remove SQL and install it all over again with the correct data paths listed.

I thought I was going to have to change about 10 servers that all had been updated with server packs and the systems guys where going to have to reinstall them all. It looks like I notified them in time so they where able to change their install plan for the majority of the servers. Thanks again guys, and yeah I was freaking out a bit.
MyDoggieJessie
MyDoggieJessie
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12626 Visits: 7444
Well that is good news, however if you post the errors the people willing to help just might be able to help you through the situation...so in the future should you ever need to do something like this again, you will be better prepared?

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience" ;-)
h2.huang
h2.huang
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 Visits: 34
Since we will get rid of T drive which I had put as SQL Data Root Directory when I installed SQL 2012SP1 before, so I have moved all system databases from (T drive) drive to another SAN drive (R: drive) and brought up sql running successfully. But I have following concerns before we get rid of T drive...

1. Can I just copy/paste other files /folders over to the R drive without impact bring up sql server?
Other files/folders are (5 MS_AgentSignnningCertificate% files on DATA folder) or folders (Backup, repldata (no data at all) and FTData folder which has 1 folder 'filterData' created on the date installed, and many other old date xml files)

2. The registry key of 'SQLDataRoot' under \\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.MSSQLSERVER\Setup\ is still showing the old SQL Data root directory 'T:\SQL2012ENT64\SYSTEMDB\MSSQL11.MSSQLSERVER\MSSQL' which I setup before. Is this going to impact sql server running after we get rid of T drive? Or, is there anyway to modify it to the right new drive R without from regedit?

3. Do we have to use exact same folder format (ending with MSSQL11.MSSQLSERVER\MSSQL\) for the new data root directory? I moved all system databases files to the new drive R:\SQL2012ENT64\SYSTEMDB\DATA without any problem to bring up sql server. but not sure if it'll be ok after copy all files over?
h2.huang
h2.huang
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 Visits: 34
Since we will get rid of T drive which I had put as SQL Data Root Directory when I installed SQL 2012SP1 before, so I have moved all system databases from (T drive) drive to another SAN drive (R: drive) and brought up sql running successfully. But I have following concerns before we get rid of T drive...

1. Can I just copy/paste other files /folders over to the R drive without impact bring up sql server?
Other files/folders are (5 MS_AgentSignnningCertificate% files on DATA folder) or folders (Backup, repldata (no data at all) and FTData folder which has 1 folder 'filterData' created on the date installed, and many other old date xml files)

2. The registry key of 'SQLDataRoot' under \\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.MSSQLSERVER\Setup\ is still showing the old SQL Data root directory 'T:\SQL2012ENT64\SYSTEMDB\MSSQL11.MSSQLSERVER\MSSQL' which I setup before. Is this going to impact sql server running after we get rid of T drive? Or, is there anyway to modify it to the right new drive R without from regedit?

3. Do we have to use exact same folder format (ending with MSSQL11.MSSQLSERVER\MSSQL\) for the new data root directory? I moved all system databases files to the new drive R:\SQL2012ENT64\SYSTEMDB\DATA without any problem to bring up sql server. but not sure if it'll be ok after copy all files ove
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search