Link to home
Start Free TrialLog in
Avatar of boxer327
boxer327

asked on

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

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?
SOLUTION
Avatar of Member_2_861731
Member_2_861731
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Avatar of boxer327
boxer327

ASKER

I want to make a copy of the existing database and run it as a separate instance.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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).
Just backup the database and create new for restore a copy as you require. there is no down time to take backup.