Sunday, March 25, 2012

Copy DB for testing purposes

I have a DB I want to make a copy of for testing purposes so we don't crash our production DB. I want the new "Test" DB to reside in the same SQL Server Group on the same SQL server. I have tried the Copy DB wizard but it will not allow you to copy the DB to the same server. What is the best way to do this?Take a backup of the prod db ... restore as a different db name ...|||I'll give it a try..

Thanks,
rbrady|||Refer to books online for BACKUP/RESTORE topic on more information.
But its better to restore the database on different rather on the same machine which may have issues with the testing.

No comments:

Post a Comment