August 31, 2012 at 9:55 am
does taking tail log back up changes the lsn
August 31, 2012 at 11:48 am
Define 'change the lsn'
What is the problem or reason behind this question?
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
September 3, 2012 at 7:12 am
asked in interview friend...
September 3, 2012 at 7:19 am
To answer that needs more info about what the interviewer meant by 'change the LSN' (he could be referring to the tran log's current LSN or MinLSN, or any one of several LSNs that are recorded in the data file, or he could have meant something completely different)
In the meantime, why don't you have a look in Books Online and see what a tail log backup does.
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
September 3, 2012 at 7:28 am
A couple articles for you:
Books Online: Tail-Log Backups (SQL Server 2012)
A good, basic overview of the concept and why you would use it: Backing up the tail
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply