Posted by Plamen Ratchev on 05/16/07 18:22

Normally a backup or the production database and restore to test works best.
In SQL Server 2005 I would do a copy-only backup.

Here is the syntax for copy-only full backup:

BACKUP DATABASE production_db_name TO <backup_device> . WITH COPY_ONLY .

Note that SSMS does not support copy-only backup, you have to run a script.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: SQL Server 2005 SSIS Progress Question
• Prev in forum: SqlServer 2005: How *best* to copy one database to another
• Thread view: Re: SqlServer 2005: How *best* to copy one database to another

[Reply to this message]