3.1.2 How Do I Make a Copy of a Database on the Same Server?

3.1.2.1 Objectives
3.1.2.2 Example Execution
3.1.2.3 Discussion
3.1.2.4 Permissions Required
3.1.2.5 Tips and Tricks
3.1.2.6 Risks

If you are working with a database and want to experiment with changes to objects or data either from direct manipulation (SQL commands) or as a result of interaction with an application, it is prudent to always have a copy to fall back to if something should go wrong.

Naturally, a full backup is key for any production server but what if you just want to do something as a test or as a prototype? Sure, you can restore from your backup when the test is complete but who has the time for that? Why not just make a copy of the database in question and use it?