Moving SQL server installation from one Drive letter to another.

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
>

Moving SQL server installation from one Drive letter to another.

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
Moving 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...;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.googlegr oups.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
>

Moving SQL server installation from one Drive letter to another.

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/defaul...b;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
>

Moving RS to other server

Hi,
We've a RS separated in two machines (Services and Databases). This database
was moved tho a new blade server with Win2003 Server and MS SQL Server 2000
Standard and now whe need to move RS to this machine.
Move database its easy... but not the services.
We try to install it, but standard version do not alow this...
How i can move RS to this new server?
Thanks.
--
Carlos E. Mosquera
DBA - Project Manager
BAC PanamáYou have to install the ReportingServer on the new server, because services
and depending files are only installed in the installing process. After
installing you can restore the ReportServer evtl. the ReportServer database
and restore the symetric key ou backuped on your old server on the new one
and violá. New Server should work now.
HTH, Jens Suessmeyer.
http://support.microsoft.com/default.aspx?scid=kb;en-us;842425
"Carlos E. Mosquera" <CarlosEMosquera@.discussions.microsoft.com> schrieb im
Newsbeitrag news:DB0CCC61-5C94-4A83-A1E5-5B0884372318@.microsoft.com...
> Hi,
> We've a RS separated in two machines (Services and Databases). This
> database
> was moved tho a new blade server with Win2003 Server and MS SQL Server
> 2000
> Standard and now whe need to move RS to this machine.
> Move database its easy... but not the services.
> We try to install it, but standard version do not alow this...
> How i can move RS to this new server?
> Thanks.
> --
> Carlos E. Mosquera
> DBA - Project Manager
> BAC Panamá