Copying a database from SQL Server machine to another

[rplcmint]

I am setting up a new machine that will be a back up for the existing one.

I have installed sql server on the 2nd machine. What I want to do is copy the 1st machine database to the second.
I tried to use the Transfer manager will all options on ..but I get errors. Something like "Dependencies exists among tables."....

I thought it would be an easy task..and I hope I don't have to write scripts to generate the tables first, and indexes and constraints and all, apply them, and then I load data using BCP (but formatting before I can load it)....cause really I don't know how...I'm a programmer, Jim!!!

But if I have to do that for success..well I'll have the experience under my belt.

I appreciate your input.

 

[foxdev]

Something like "Dependencies exists among tables."....

A bit vague, but I've done this dozens of times and the only hiccups I get are for users (especially domain users that don't exist on the target server). Try just checking the options for the database and tables and see if that works, then go up from there. Robert Bradley

http://www.foxdev.com/

Do you have too much money? Visit

http://www.agrainofhope.org