Need your response urgently:

[HenryMonster]

Hi All,

Need your help urgently !!!

I need to clone a database (mydb_prod) on the same
MS SQL server under a different name (say mydb_test).

We do not have a luxury of another machine at the time.

THANK YOU VERY MUCH IN ADVANCE !

 

[ecobb]

Backup the database, and then restore it under a different name. Or, if you only need the schema, just script the database and rename it when you run the script in Query Analyzer.

Hope This Helps!

Ecobb
- I hate computers!

 

[amanx]

If you do the restore on the same server -
Make sure you restore the Log and Data file under a differnet name (then your source db files that is). You can access this info under the options tab of the restore window.

thx