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-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20606 Visits: 17244
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
Old Hand
Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)Old Hand (328 reputation)

Group: General Forum Members
Points: 328 Visits: 538
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
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6758 Visits: 7394
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
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 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
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 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