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