Solved

We have an SQL 2008 R2 database instance running 24/7. I need to make a copy of it that instance and run it as a test database on the same server with no down time or interference with the existing

Posted on 2013-01-08
7
269 Views
Last Modified: 2013-01-13
We have an SQL 2008 R2 database instance running 24/7. I need to make a copy of it that instance and run it as a test database on the same server with no down time or interference with the existing database. I want to run them on the same server as separate instances.  Can anyone help me do this without interfering with the existing instance?
0
Comment
Question by:boxer327
[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
7 Comments
 
LVL 13

Assisted Solution

by:LIONKING
LIONKING earned 250 total points
ID: 38755168
Do you want to make another SQL Server "Instance" or just copy the database and use it for testing purposes?

If you want to make another SQL Server instance, you will have to run the installer all over again, name your instance and configure it with the same values as the one you have running.
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 38755184
The procedure is pretty simple.

Take a backup of the existing database, then restore it as a new database.

You can do that as a database in a new instance (as noted by LIONKING) or as a database in your existing instance.
0
 

Author Comment

by:boxer327
ID: 38755983
I want to make a copy of the existing database and run it as a separate instance.
0
 Watch the Recording: Learning MySQL 5.7

MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.

 
LVL 22

Accepted Solution

by:
Steve Wales earned 250 total points
ID: 38756015
Then the above couple of posts will work.

Take a backup of you current database.
Install a new instance on the server.
Restore the backup to the new instance.

Done!
0
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 38756161
When you restore the db, be sure that you override the existing file names, otherwise you might damage the original db (SQL is pretty good about preventing you from doing that, but you might be able to force it to happen).
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 38758495
Just backup the database and create new for restore a copy as you require. there is no down time to take backup.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

630 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