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
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?
Question by:boxer327
LVL 13

Assisted Solution

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.
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.

Author Comment

ID: 38755983
I want to make a copy of the existing database and run it as a separate instance.
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!

LVL 22

Accepted Solution

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.

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).
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.

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Abstract Express Replacement Software 12 28
Show Results for Latest DateTime in a View 27 25
sql server service accounts 4 27
SQL Function NOT ROUND 9 10
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

803 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