I'm hoping you can help a newbie with a quick question. I need to move
an installation of SQL server 2000 sp3a on a Win2003 Standard server
from the C Drive to the D drive. I'm running out of room on the C Drive
and have more then enough room on the D drive. I know you can detach
databases and move the files and attach them again but I'm looking to
move the whole "C:\Program Files\Microsoft SQL Server" folder to
"D:\Program Files\Microsoft SQL Server"
Is this possible and if so how do you do it? I've seen web pages on how
to move an installation of SQL server from one server to another but
that is not what I'm needing to do.
Thanks in advance,
NathanMoving the complete folder \Program Files\Microsoft SQL Server will pretty
much require a reinstall, if you want to be safe. Just moving the data and
log files ( see
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224071) and the
backups, will leave with a more or less basic install of SQL Server, which
takes about 250 MB. That might solve your needs.
--
Jacco Schalkwijk
SQL Server MVP
<nbheck@.hotmail.com> wrote in message
news:1111037005.791634.315720@.z14g2000cwz.googlegroups.com...
> I'm hoping you can help a newbie with a quick question. I need to move
> an installation of SQL server 2000 sp3a on a Win2003 Standard server
> from the C Drive to the D drive. I'm running out of room on the C Drive
> and have more then enough room on the D drive. I know you can detach
> databases and move the files and attach them again but I'm looking to
> move the whole "C:\Program Files\Microsoft SQL Server" folder to
> "D:\Program Files\Microsoft SQL Server"
> Is this possible and if so how do you do it? I've seen web pages on how
> to move an installation of SQL server from one server to another but
> that is not what I'm needing to do.
> Thanks in advance,
> Nathan
>
No comments:
Post a Comment