Solved

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

Posted on 2011-03-07
4
319 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

717 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