• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • Last Modified:

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?
0
boxer327
Asked:
boxer327
2 Solutions
 
LIONKINGCommented:
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
 
Steve WalesSenior Database AdministratorCommented:
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
 
boxer327Author Commented:
I want to make a copy of the existing database and run it as a separate instance.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Steve WalesSenior Database AdministratorCommented:
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
 
Scott PletcherSenior DBACommented:
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
 
Alpesh PatelAssistant ConsultantCommented:
Just backup the database and create new for restore a copy as you require. there is no down time to take backup.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now