Duplicating a database on the same server 1

[achmo]

Hello,

I'm planning on doing some changes to my SQL Server 2000 database, and I don't want to do them directly on the working database. So i though I could duplicate the database, work on the new one, and when everything works fine copy the new database back to the old one.

So how do I do that? The Copy Database Wizard only copies between servers, and to use DTS I whould have to recreate the structure of the database before copying, and that would be * a lot * of work...

Ideas, anyone?

Thank you very much!

Yael

 

[moonshadow]

Backup the database, and restore it over the top of the other

 

[achmo]

Great! Worked like a charm. Thanks!