Rats - I just spent the last half an hour typing out the various steps - only to have the whole text "vanish" - ctrl z isn't bringing it back to life either

at any rate - jason hall's method:

click on the wizard icon (the magic wand) on the tool bar of enterprise manager, go to "management" - "backup wizard" - it'll walk you through all the steps - copy the backup file which will be saved with a .bak extension in your backup folder - save it in a folder in your target server - create a brand new database in the target server - - and right click - select "all tasks" - "restore database" - "from device" - "select devices" - "add" - navigate to saved .bak file and open - say "ok"

sqlbill's is to right click - select "all tasks" - detach database - go to the data folder which will have saved your data and log files with an .mdf and .ldf extension - copy these files - and then "attach" them in the target server. However, if you're new to all this - my suggestion would be to do it Jason's way - it's easier to follow!

A third way - if you have only created the tables but not populated it with any data - is to right click on one of the tables - select "all tasks" - "generate sql script" - "show all" - and under the options tab - select either "create one file" or "create one file per object" - then you can copy this/these file/s and run the script in the query analyzer (after having created a new database in the target server).

Use BOL (books on line) for help and guidance regardless of the method you choose. Everything seems difficult when it is new but with practice you'll be surpised how easy and effortless it all becomes. Good luck!