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 databases
Hi,
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 system to the new server. I have done this on many occasions. I always double check @.@.servername on the ne
w server when I am done.
On the new server just rename the SQL Directories before you copy the old ones over. This will give you something to fall back on just in case of failure. Copy all the mdf's and ldf's to the same location on the new box.
Jeff
MCDBA, MCSE+I