DBA - Maintenance Plan "Back Up Database Task" Copy-only Backup Option Included SQL Server 2012

We were able to 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".

"Back up the tail of the log, and leave the database in the restoring state" Option  that was available in SQL server 2008 "Back Up Database Task" is now removed in SQL Server 2012 "Back Up Database Task" in Maintenance Plan.

Maintenance Plan--> Back Up Database Task SQL Server 2008/2008R2
How to take Copy Only backup in SQL Server 


Maintenance Plan--> Back Up Database Task SQL Server 2012
How to perform Copy-Only Backup in SQL Server

For more detail , please visit
http://msdn.microsoft.com/en-us/library/ms191495.aspx


1 comment: