Sql Case sensitivity: Change Drive Letter

With reference to my previous posting, it seems that there
may be some misunderstanding.
We have installed a SQL Server 2000 database on the J
drive. However, we would like to rename the J drive to E
drive (Asked by the Network Administrator).
We would like to know is it necessary for us to do
anything for the change of drive letter ? Is it necessary
for us to detach and attach the database when he changes
the drive name? OR Just change the file location of the
database from J to E in EM?
ThanksThis is a multi-part message in MIME format.
--070500050405010801060608
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Renaming drive letters is really ugly. If you just rename the drive
letter then SQL Server probably wont even start because it will be
looking for the master database primary data file on the wrong drive
letter (which will no longer exist). This can be changed in the
registry but there are a myriad of other problems you will encounter.
It may be best just to detach all you user DBs, uninstall SQL Server,
rename the drive letters, reinstall SQL Server and reattach your user
DBs again (now located on the renamed drive letter). If you'd already
done a fair bit of server config you may want to backup your master,
model & msdb (and potentially distribution DB if configured as a
distributor participating in SQL replication) databases before
uninstalling SQL Server and then restore them after reinstalling.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Jason wrote:
>With reference to my previous posting, it seems that there
>may be some misunderstanding.
>We have installed a SQL Server 2000 database on the J
>drive. However, we would like to rename the J drive to E
>drive (Asked by the Network Administrator).
>We would like to know is it necessary for us to do
>anything for the change of drive letter ? Is it necessary
>for us to detach and attach the database when he changes
>the drive name? OR Just change the file location of the
>database from J to E in EM?
>Thanks
>
>
--070500050405010801060608
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Renaming drive letters is really ugly. If you just rename the
drive letter then SQL Server probably wont even start because it will
be looking for the master database primary data file on the wrong drive
letter (which will no longer exist). This can be changed in the
registry but there are a myriad of other problems you will encounter. 
 
It may be best just to detach all you user DBs, uninstall SQL Server,
rename the drive letters, reinstall SQL Server and reattach your user
DBs again (now located on the renamed drive letter). If you'd already
done a fair bit of server config you may want to backup your master,
model & msdb (and potentially distribution DB if configured as a
distributor participating in SQL replication) databases before
uninstalling SQL Server and then restore them after reinstalling.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
Jason wrote:
<blockquote cite="mid142001c5708a$b5113a10$a401280a@.phx.gbl" type="cite">
<pre wrap="">With reference to my previous posting, it seems that there
may be some misunderstanding.
We have installed a SQL Server 2000 database on the J
drive. However, we would like to rename the J drive to E
drive (Asked by the Network Administrator).
We would like to know is it necessary for us to do
anything for the change of drive letter ? Is it necessary
for us to detach and attach the database when he changes
the drive name? OR Just change the file location of the
database from J to E in EM?
Thanks
</pre>
</blockquote>
</body>
</html>
--070500050405010801060608--|||Actually, this is not as dramati as Mike depicted, but backing up before
doing anything else is always a good idea. Check this article for details:
http://www.support.microsoft.com/kb/224071/EN-US/
"Mike Hodgson" wrote:
> Renaming drive letters is really ugly. If you just rename the drive
> letter then SQL Server probably wont even start because it will be
> looking for the master database primary data file on the wrong drive
> letter (which will no longer exist). This can be changed in the
> registry but there are a myriad of other problems you will encounter.
> It may be best just to detach all you user DBs, uninstall SQL Server,
> rename the drive letters, reinstall SQL Server and reattach your user
> DBs again (now located on the renamed drive letter). If you'd already
> done a fair bit of server config you may want to backup your master,
> model & msdb (and potentially distribution DB if configured as a
> distributor participating in SQL replication) databases before
> uninstalling SQL Server and then restore them after reinstalling.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>
> Jason wrote:
> >With reference to my previous posting, it seems that there
> >may be some misunderstanding.
> >
> >We have installed a SQL Server 2000 database on the J
> >drive. However, we would like to rename the J drive to E
> >drive (Asked by the Network Administrator).
> >
> >We would like to know is it necessary for us to do
> >anything for the change of drive letter ? Is it necessary
> >for us to detach and attach the database when he changes
> >the drive name? OR Just change the file location of the
> >database from J to E in EM?
> >
> >Thanks
> >
> >
> >
> >
>|||This is a multi-part message in MIME format.
--070302090901030006050107
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
That KB article is assuming the binaries directory is not moving too. I
may have misread/misunderstood the OP. I was basing the
uninstall/reinstall suggestion on the presumption that the whole SQL
installation was on the disk to be renamed (binaries, data files, log
files, tempdb, the works). I agree that if the binaries are staying
where they are (eg. on C:\Program Files\...) the you can move DBs
without the need to uninstall/reinstall and if the system DBs (master,
msdb & model) don't need to move then the process is virtually painless
with a simple detach/attach process.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
rdjabarov wrote:
>Actually, this is not as dramati as Mike depicted, but backing up before
>doing anything else is always a good idea. Check this article for details:
>http://www.support.microsoft.com/kb/224071/EN-US/
>"Mike Hodgson" wrote:
>
>>Renaming drive letters is really ugly. If you just rename the drive
>>letter then SQL Server probably wont even start because it will be
>>looking for the master database primary data file on the wrong drive
>>letter (which will no longer exist). This can be changed in the
>>registry but there are a myriad of other problems you will encounter.
>>It may be best just to detach all you user DBs, uninstall SQL Server,
>>rename the drive letters, reinstall SQL Server and reattach your user
>>DBs again (now located on the renamed drive letter). If you'd already
>>done a fair bit of server config you may want to backup your master,
>>model & msdb (and potentially distribution DB if configured as a
>>distributor participating in SQL replication) databases before
>>uninstalling SQL Server and then restore them after reinstalling.
>>--
>>*mike hodgson* |/ database administrator/ | mallesons stephen jaques
>>*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
>>*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>>
>>Jason wrote:
>>
>>With reference to my previous posting, it seems that there
>>may be some misunderstanding.
>>We have installed a SQL Server 2000 database on the J
>>drive. However, we would like to rename the J drive to E
>>drive (Asked by the Network Administrator).
>>We would like to know is it necessary for us to do
>>anything for the change of drive letter ? Is it necessary
>>for us to detach and attach the database when he changes
>>the drive name? OR Just change the file location of the
>>database from J to E in EM?
>>Thanks
>>
>>
>>
--070302090901030006050107
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>That KB article is assuming the binaries directory is not moving
too.Â I may have misread/misunderstood the OP.Â I was basing the
uninstall/reinstall suggestion on the presumption that the whole SQL
installation was on the disk to be renamed (binaries, data files, log
files, tempdb, the works).Â I agree that if the binaries are staying
where they are (eg. on C:\Program Files\...) the you can move DBs
without the need to uninstall/reinstall and if the system DBs (master,
msdb & model) don't need to move then the process is virtually
painless with a simple detach/attach process.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
rdjabarov wrote:
<blockquote cite="mid575074A1-CCF2-4720-B520-06EBD8D11D34@.microsoft.com"
type="cite">
<pre wrap="">Actually, this is not as dramati as Mike depicted, but backing up before
doing anything else is always a good idea. Check this article for details:
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.support.microsoft.com/kb/224071/EN-US/</a>">http://www.support.microsoft.com/kb/224071/EN-US/">http://www.support.microsoft.com/kb/224071/EN-US/</a>
"Mike Hodgson" wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Renaming drive letters is really ugly. If you just rename the drive
letter then SQL Server probably wont even start because it will be
looking for the master database primary data file on the wrong drive
letter (which will no longer exist). This can be changed in the
registry but there are a myriad of other problems you will encounter.
It may be best just to detach all you user DBs, uninstall SQL Server,
rename the drive letters, reinstall SQL Server and reattach your user
DBs again (now located on the renamed drive letter). If you'd already
done a fair bit of server config you may want to backup your master,
model & msdb (and potentially distribution DB if configured as a
distributor participating in SQL replication) databases before
uninstalling SQL Server and then restore them after reinstalling.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a> |* W* <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.mallesons.com</a>">http://www.mallesons.com">http://www.mallesons.com</a>
Jason wrote:
</pre>
<blockquote type="cite">
<pre wrap="">With reference to my previous posting, it seems that there
may be some misunderstanding.
We have installed a SQL Server 2000 database on the J
drive. However, we would like to rename the J drive to E
drive (Asked by the Network Administrator).
We would like to know is it necessary for us to do
anything for the change of drive letter ? Is it necessary
for us to detach and attach the database when he changes
the drive name? OR Just change the file location of the
database from J to E in EM?
Thanks
</pre>
</blockquote>
</blockquote>
</blockquote>
</body>
</html>
--070302090901030006050107--

Sunday, March 25, 2012

Change Drive Letter

No comments:

Post a Comment

Sql Case sensitivity

Blog Archive

About Me