October 28, 2002 at 3:49 pm
I'm doing log shipping on SQL 2000 to a warm standby server and every night the main database backup succeeds as does a DBCC CheckDB. Problem however, is that by the second transaction log backup of the day (sometimes first sometimes second) I get the following error:
Error: 3456, Severity: 21, State: 1
Could not redo log record (23796:247:6), for transaction ID (0:32001060), on page (1:138023), database 'my_database' (8). Page: LSN = (22607:583:512), type = 1. Log: OpCode = 2, context 3, PrevPageLSN: (23796:236:6).
I couldn't find much info about this in BOL or MSDN. Any thoughts as to why it couldn't roll forward a transaction etc.?
October 28, 2002 at 6:01 pm
October 29, 2002 at 1:53 am
Thanks Andy, checked out the article and we're running SQL 2000 SP2. Also our Server is already on Full Recovery Mode. The interesting thing is that I switched the recovery model on that server from Full to Bulk-Logged for a couple of hours on Saturday while I did some bcp work, then switched it back to Full Recovery. The problems only surfaced on Saturday night's backup and have been there ever since. I ran ALTER DATABASE <DBNAME> SET RECOVERY FULL in Query Analyser... will let you know if probs still exist 2moro.
Thanks
Luke
November 4, 2002 at 7:33 pm
The actual problem turns out to be: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q329487 incase anyone else suffers the same fate as myself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply