Solved

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

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

805 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