We have installed a SQL Server 2000 database on the J
drive. However, we would like to change the drive letter
to E.
We would like to know what steps we should do in order to
move the database from J to E drive ? Is it necessary for
us to detach and attach the database ? OR Just change the
file location of the database from J to E in EM?
ThanksYou would need to detatch the database, move the files and then re-attach
the files to bring the DB back online. When re-attaching the files however
you will be able to browse for the .MDF file. If there are any subsequent
files such as .NDF or .LDF you *may* need to search for them separatly.
When detatching a database if you have any full text searches enabled on the
DB, these will need to be re-established once the database is re-attached.
This can be done by right clicking on the table with the full text index and
then proceeding to 'edit' the index.
Hope this helps.
Anubis.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:018701c5707c$2f643880$a601280a@.phx.gbl...
> We have installed a SQL Server 2000 database on the J
> drive. However, we would like to change the drive letter
> to E.
> We would like to know what steps we should do in order to
> move the database from J to E drive ? Is it necessary for
> us to detach and attach the database ? 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.
--020308090700050707010001
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
If it's just a single DB you're talking about, detach/attach would be
the best way. I'd strongly advise *against* hacking the system tables
to change the driver letter in sysfiles.
--
*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:
>We have installed a SQL Server 2000 database on the J
>drive. However, we would like to change the drive letter
>to E.
>We would like to know what steps we should do in order to
>move the database from J to E drive ? Is it necessary for
>us to detach and attach the database ? OR Just change the
>file location of the database from J to E in EM?
>Thanks
>
--020308090700050707010001
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>If it's just a single DB you're talking about, detach/attach would
be the best way. I'd strongly advise <b>against</b> hacking the
system tables to change the driver letter in sysfiles.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
Jason wrote:
<blockquote cite="mid018701c5707c$2f643880$a601280a@.phx.gbl" type="cite">
<pre wrap="">We have installed a SQL Server 2000 database on the J
drive. However, we would like to change the drive letter
to E.
We would like to know what steps we should do in order to
move the database from J to E drive ? Is it necessary for
us to detach and attach the database ? OR Just change the
file location of the database from J to E in EM?
Thanks
</pre>
</blockquote>
</body>
</html>
--020308090700050707010001--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment