October 5, 2015 at 12:57 pm
If Transaction Log Backup fails due to a conflict could it break the Log Chain?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 5, 2015 at 3:06 pm
No.
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 5, 2015 at 4:38 pm
You should be able to take another log backup and, assuming it succeeds, everything should be fine. You can check it by using RESTORE HEADERONLY to look at the Log Sequence Numbers (LSN) to be sure that the last of your previous good log backup and the first of your new log backup link up. Here's an article [/url]on how to read the information from your backups.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 5, 2015 at 4:56 pm
Is this related to not being able to see a backup file at http://www.sqlservercentral.com/Forums/Topic1725461-2799-1.aspx?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply