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
Maintenance Plan--> Back Up Database Task SQL Server 2012
For more detail , please visit
http://msdn.microsoft.com/en-us/library/ms191495.aspx
"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 |
http://msdn.microsoft.com/en-us/library/ms191495.aspx
Mua vé máy bay tại Aivivu, tham khảo
ReplyDeletevé máy bay đi Mỹ bao nhiêu tiền
vé máy bay từ mỹ về việt nam hãng eva
vé máy bay từ đức về việt nam giá rẻ
khi nào có chuyến bay từ nga về việt nam
vé máy bay từ anh về việt nam
chuyến bay từ paris về hà nội
khách sạn cách ly ở nha trang
vé máy bay cho chuyên gia nước ngoài