DTS between servers

[KevinFSI]

Pardon my broad question here, but what is the easiest/best way to take everything from one server and put it on another.

We've thought about using DTS, or doing it all from backups, and we've explored sp_attach_db as an option as well.

Basically, we have a machine (serverA) with all of our stuff on it. We just built a new machine (serverB) and now want an exact copy of what's already on serverA to be on serverB. Kevin
slanek@ssd.fsi.com

 

[AshleyRickards]

How many databases and data are we talking about here? Ashley L Rickards
SQL DBA

 

[KevinFSI]

Roughly 15 databases, about 2 gig. Kevin
slanek@ssd.fsi.com

 

[moonshadow]

2 GB - Tiny!! DTS is not the way (if you have referential integrity, which of course you do). Others at my company would recommend backup & restores, but I'd be game for the dettach/attach database option

 

[KevinFSI]

Cool. Thanks for the info! Kevin
slanek@ssd.fsi.com

 

[KevinFSI]

Hey, what about the master db? I can't detach/attach that one can I? Kevin
slanek@ssd.fsi.com

 

[tlbroadbent]

You can restorem the master from a backup. SQL BOL outlines how to do that. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.