How can I copy a SQL 2005 Database to the same server it exists on

How can I copy a SQL 2005 Database to the same server it exists on without bringing it down, or taking it offline...

Need to do it while the production database is still upo and running.
gawhite2Asked:
Who is Participating?
 
Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
0
 
Éric MoreauSenior .Net ConsultantCommented:
backup and restore is the way to go
0
 
gawhite2Author Commented:
Thanks!
0
 
8080_DiverCommented:
However you do it, unless you set up some sort of replication, you are subject to getting a corrupted version in the new database because you may have transferred the data from one table before a transaction is committed and then another table, which has an FK constraint on the first one, gets transferred after the commit and the tables are out of synch.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.