July 23, 2012 at 1:00 pm
BACKUP DATABASE XXXXX
TO DISK = 'C:\Sqlserver\backup\xxx.bak'
with copy_only
GO
Why do we use 'Copy_Only' during a datbase backup? does this effect LSN?
In which backups do we backup mdf and ldf?
July 23, 2012 at 1:04 pm
http://sqlinthewild.co.za/index.php/2011/03/08/full-backups-the-log-chain-and-the-copy_only-option/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2012 at 1:25 pm
From MSDN:
A copy-only log backup preserves the existing log archive point and, therefore does not affect the sequencing of regular log backups.
Reference: http://msdn.microsoft.com/en-us/library/ms191495.aspx
July 23, 2012 at 1:58 pm
Vikrant S Patil (7/23/2012)
From MSDN:A copy-only log backup preserves the existing log archive point and, therefore does not affect the sequencing of regular log backups.
That is specifically talking about a copy only log backup, not a copy only full backup. I have logged a connect asking for that page to be clarified.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2012 at 8:30 am
Gail, Thanks for the update.
Really appreciate you sharing your knowledge and giving all of us a opportunity to learn from your vast experience.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply