Solved

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

Posted on 2011-03-07
4
312 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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with SQL - TOP 10 by date and by group 13 42
How can i get data when i use where clause with group by? 3 48
Replace Dates in query 14 56
kill process lock Sql server 9 75
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…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

733 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