Backing up and restoring 50 databases to a new server

I would like to replace my SQL 2000 server with a faster box. I currently
use a combination of full and transactional backups to back up the server
every day. I know that I could build a new box and restore each database
from backup file one at a time but was wondering if there was a quicker way
to store all the databasesHi,
Look in to the below web sites for various strategies to move all the
databases to new server.
Moving SQL Server Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=224071
Moving DB's between Servers
http://www.support.microsoft.com/?id=314546
Thanks
Hari
MCDBA
"Richard Zellmer" <tdmailbox@.yahoo.com> wrote in message
news:#$TGJe7IEHA.1412@.TK2MSFTNGP12.phx.gbl...
> I would like to replace my SQL 2000 server with a faster box. I currently
> use a combination of full and transactional backups to back up the server
> every day. I know that I could build a new box and restore each database
> from backup file one at a time but was wondering if there was a quicker
way
> to store all the databases
>
>|||If you have installed SQL on the new server with the same paths... I have
stopped the SQL services on both servers and copied all DB's including syste
m to the new server. I have done this on many occasions. I always double c
heck @.@.servername on the ne
w server when I am done.
On the new server just rename the SQL Directories before you copy the old on
es over. This will give you something to fall back on just in case of failu
re. Copy all the mdf's and ldf's to the same location on the new box.
Jeff
MCDBA, MCSE+I