Posted by Steve on 05/17/07 01:58

On May 16, 2:22 pm, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote:
> 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.

Why is it called a copy only backup?

Is there an option for non-admins?

My test database has a different name ( but identical schema ), once
copy-only backed up, and restored would my admin just then change the
name ( after dropping the old test database? ).

• Next in forum: Re: SqlServer 2005: How *best* to copy one database to another
• Prev in forum: Re: Search for a table/string within job steps, dts, database, stored procedures etc
• Thread view: Re: SqlServer 2005: How *best* to copy one database to another

[Reply to this message]