How does one make a copy of a database (with the data) on the same
server. Would like to do this to use the copy in a test environment. I
looked at the Copy Database Wizard but the instructions in Books Online
state that the database must be copied to another server and cannot be
renamed using this process.
Thank you.

<JJ_377 (AT) hotmail (DOT) com> wrote

Backup and restore is usually the easiest option - see example E under
RESTORE in Books Online, and also this KB article:

http://support.microsoft.com/default...b;en-us;314546

Simon

thank you for the reference.