?
Solved

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

Posted on 2011-03-07
4
Medium Priority
?
329 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:gawhite2
  • 2
4 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 35060080
backup and restore is the way to go
0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 2000 total points
ID: 35060149
0
 

Author Closing Comment

by:gawhite2
ID: 35061660
Thanks!
0
 
LVL 22

Expert Comment

by:8080_Diver
ID: 35061874
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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Integration Management Part 2
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question