problem with full backup with copy only in maintenance plan sql server 2008

Hello

I am starter DBA for sql server in general

I have problem related to backup with maintenance plan in sql server 2008 and 2008 r2

I created maintenance plan to take full back up  with copy only option checked, but when I check the back up in backupset table is_copy_only column it shows 0 for databases that I run job for.

I did the same steps on sql server 2012 and I checked backupset table is_copy_only column it shows 1 for databases that I run job for .so it works as it should be

Note: all the servers I mention here are production servers 


March 25th, 2015 5:19am

Hello,

My understanding is that the copy-only backup option on maintenance plans is available on SQL Server 2012 and later only.

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Free Windows Admin Tool Kit Click here and download it now
March 25th, 2015 9:01am

thank you sir for answering

I looked up at msdn documentation and it say copy only being supported by Management Studio 2008 and later

https://msdn.microsoft.com/en-us/library/ms191495(v=sql.100).aspx

my problem is I checked copy only backup but when I check msdb..backupset table is_copy_only column it shows 0

and thats mean is copy only = false

this problem only appear in Sql server 2008 and 2008 R2 but in 2012 work fine

Note: I am using ssms2012

March 26th, 2015 1:56am

Copy-only Backup  by using GUI ( SSMS) in SQL Server 2008 but it was not available in  Maintenance Plan "Back Up Database Task". Now in SQL Server 2012 It is included in "Back Up Database Task"

http://sqlage.blogspot.in/2013/06/dba-maintenance-plan-back-up-database.html

Free Windows Admin Tool Kit Click here and download it now
March 26th, 2015 2:24am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics