Copying a database

[MarkGreen]

Hi,
I have been designing a database using access/SQL server and it is now ready for users to start using.
However I need to make a copy of this database on the same SQL server so I can continue to develop and test my access front end without affecting the live data.
I've trid copy database wizard but it doesnt seem to allow copying to the same server.

Is this possible and if so, what is the simplest way?

Thanks,
Mark.

 

[vadimg]

i think the easiest way would be to:
1. backup the existing database
2. create an empty database on the same server
3. restore the backup into the empty database (don't forget to specify the new .mdf/.ldf filenames).

hope this helps

 

[tlbroadbent]

You can omit step 3. Backups can be restored to a new databse. SQL will create it for you. It will even name the physical files properly if you use Enterprise manage to restore. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm