Creating a copy-only backup (SQL Server 2005 or later)

Any backup can be created as copy-only in SQL Server 2005 or later. A persistent frozen image snapshot is automatically created as copy-only. You can also create a snapshot that is NOT copy-only.

To create a copy-only backup

  1. Open an existing batch file in a text editor.

  2. Insert the following:

    COPYONLY TRUE
    
  3. Save the batch file.

More Information

Creating a cloaked backup (SQL Server 2000)