How to create exact copy of existing SQL Serevr 2000 database with all objects?

Thanks.
quasar_eeAsked:
Who is Participating?
 
MikeWalshCommented:
Right click on your database in enterprise manager and choose all tasks --> backup database.

Make a backup. Then you ahve a full copy. You can restore this somewhere else to use that full copy.
0
 
SireesCommented:
Take a backup of your database and restore it to a different location to have exact copy of database.
0
 
MikeWalshCommented:
Thanks for agreeing with me sirees..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.