Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

10775: copy_only in sql server 2005 or 2008

Posted on 2015-02-17
2
Medium Priority
?
142 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 2000 total points
ID: 40615999
HI,

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

Expert Comment

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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

916 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