Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Server Migration
Message
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
00812470
Message ID:
00812609
Views:
12
Well, there is the copy database wizard.

I've always used backup/restore for this type of operation.

-Mike

>What would be the simplest way to copy all the data (system and user db's) from one sql server to a new fresh sql server on a new machine? I figured I could just to a full backup of all the db's but that creates seperate files for each db and there is about 30 db's on this server and I dont want to do a seperate restore for each one. But, if thats the only option.. I just have to do it. What do you reccommend?
>
>Eric Stephani
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform