October 23, 2015 at 3:06 am
Hi,
Ex :
My backup strategy is like the following
every 24 h full backup,
every 3h differential backup
every 1h log backup.
I have a question i.e
i have taken the full backup and inserted 100 transactions ,
How sql server will identify those 100 transactions should comes under the differential backup.
🙂
Regards
Chowdary...
October 23, 2015 at 3:26 am
The transactions after the full backup would have flipped the relevant bits in the Differential Change Map, flagging the affected extents as ones which need to be included in differential backups
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
October 23, 2015 at 4:15 am
Thank you Gail Shaw,
Is there any article on that topic , Because as am having less hands on exp on that.
Regards
Chowdary...
October 23, 2015 at 4:20 am
Should be some in Books Online. Have a read through the docs on full, diff and log backups and how they work.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply