Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Copy_Only like option for SQL Server 2000 Expand / Collapse
Author
Message
Posted Thursday, May 10, 2007 4:17 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 207, Visits: 201

Does anyone know if there is an option in 2000 like the Copy_Only in 2005? 

Copy_Only option from BOL:

Taking a backup normally changes the database, in turn affecting other backups and how they are restored. Sometimes, however, a backup must be taken for a special purpose that should not affect the overall backup and restore procedures for the database.

A data backup is normally a base backup for one or more differential backups taken after it. Microsoft SQL Server 2005 introduces support for creating copy-only backups, which do not affect the normal sequence of backups. Therefore, unlike other backups, a copy-only backup does not impact the overall backup and restore procedures for the database.

You can create a copy-only backup for any type of backup:

  • Copy-only data backups (all recovery models)

    To create a copy-only data or differential backup, use the COPY_ONLY option in your BACKUP DATABASE statement. A data backup taken with the COPY_ONLY option cannot be used as a base backup and does not affect any existing differential backups.

  • Copy-only differential backups

    These are identical to regular differential backups.

  • Copy-only log backups

    To create a copy-only log backup, use the COPY_ONLY option in your BACKUP LOG statement; doing so causes backup to retain the current log archive point. Also, the transaction log is not truncated by a log backup taken using the COPY_ONLY option. Without COPY_ONLY, a BACKUP LOG WITH NORECOVERY would advance the log archive point.



Post #364935
Posted Thursday, May 10, 2007 5:03 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:37 AM
Points: 4,064, Visits: 5,339

No, Copy-only is a new feature in SQL 2005.  I think the closest you'd get in SQL 2000 would be to use BCP or DTS to export data. 

Greg



Greg
Post #364942
Posted Friday, May 11, 2007 7:51 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 207, Visits: 201
Thanks for the reply Greg.  That is what I figured, but I wanted to make sure.


Post #365113
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse