June 17, 2011 at 7:17 am
Hi All,
Currently, I have my SQL Server 2005 installed on the D drive of the server. My question is if i change the drive letter, what impact will it have?
Will i need to re-install?
With Thanks,
Satnam
June 17, 2011 at 9:43 am
Do you mean you have the SQL application installed on D:\ or just the database .mdf and .ldf?
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
June 17, 2011 at 10:24 am
Just the SQL Application itself.
June 17, 2011 at 10:30 am
I would avoid it in this case unless you are prepared to move system databases and the resource database.
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
June 17, 2011 at 10:39 am
What about if i have seperate drives for Tempdb(F) and SQL Backups(H) on a cluster and i want to change their letters to T and B respectively, they dont have anything apart from this inside it. I feel that doing this doesn't have any risks, but still want to know your view.
Satnam
June 17, 2011 at 10:43 am
Changing drive locations for Backups and tempdb is a lot less risky and more straight forward. Make sure you change your backup jobs for the new drive letter.
There isn't much concern around changing those. I might avoid B though since it is historically reserved for floppy drives (not present on the server I am sure - but best to avoid the possibility).
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply