enrique_aeo
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Right. Copy_Only option exists since SQL Server 2005.