Thanks for the input.. Ill probably end up doing it this way.

>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