Solved

10775: copy_only in sql server 2005 or 2008

Posted on 2015-02-17
2
113 Views
Last Modified: 2015-02-19
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
Comment
Question by:enrique_aeo
2 Comments
 
LVL 6

Accepted Solution

by:
Mandeep Singh earned 500 total points
ID: 40615999
HI,

You do not need to modify for SQL Server 2005 & 2008. It works fine with both.
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 40616404
Right. Copy_Only option exists since SQL Server 2005.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now