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.
Showing posts with label reside. Show all posts
Showing posts with label reside. Show all posts
Sunday, March 25, 2012
Subscribe to:
Posts (Atom)