November 12, 2008 at 12:01 am
When LSN Missing, If all the Tran log files are Not there in standby server, then we have to take latest full backup from Production and FTP to Standby server, then restore it on Standby and apply all the Tran log files from Last Latest full Backup.
But All the Tran log files are available on standby server , what are the possible reason's are there,how can i fix this problem,because it is happening daily basis for one Database.
November 12, 2008 at 12:32 am
My guess is that you're truncating the tran log at some point. Look through the jobs and see if you have a BACKUP LOG ... WITH TRUNCATE_ONLY or BACKUP LOG ... WITH NO_LOG anywhere. Those discard log records and hence break the log chain.
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 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply