Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 145
  • Last Modified:

10775: copy_only in sql server 2005 or 2008

Hi experts

i have this code
BACKUP DATABASE AdventureWorks
TO DISK = 'L:\SQLBackups\AW_Copy.bak'
WITH COPY_ONLY, INIT;

COPY_ONLY: Backup the database without changing the restore order.

I need to modify to make a COPY_ONLY in sql server 2005 or sql 2008
0
enrique_aeo
Asked:
enrique_aeo
1 Solution
 
Mandeep SinghDatabase AdministratorCommented:
HI,

You do not need to modify for SQL Server 2005 & 2008. It works fine with both.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Right. Copy_Only option exists since SQL Server 2005.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now