April 22, 2005 at 3:12 am
Hi all,
We've been experiencing an error in a log shipping solution we have set up.
Backups take place without issue, but occasionally, we're picking up an error in the restore process;
"Executed as user: NT AUTHORITY\SYSTEM. Could not redo log record (115363:95346:422), for transaction ID (0:-1773904621), on page (3:91039), database 'Standby' (14). Page: LSN = (115359:89903:75), type = 1. Log: OpCode = 3, context 2, PrevPageLSN: (115337:833:2). [SQLSTATE HY000] (Error 3456) Processed 7306 pages for database 'standby', file 'standby_log' on file 1. [SQLSTATE 01000] (Error 4035)"
We've researched this quite a bit and found 2 possible causes;
1) Index alterations at the time of a Log Backup. We've checked this out and ensured there are backup windows over index maintenance activity, and the only remaining index activity is an Index Create on a Temporary Table, so theoretically, this should have no impact? Additionally, we have many similar setups that are working perfectly fine with the Procedure described above. One question I may have here, is are there any reference to activity on Temp Tables from an originating DB?
2) We are running an MSA1000 storage unit on the source, and we've read up that stale reads have been shown to be a problem when write caching is enabled on the controllers. For various reasons, we're naturally not too keen to disable the caching, as we don't want to put any data at risk in case of a hard down. Also, this issue's internet documentation seems to be specifically centered around Transient 823's and chain link mismatch issues, which are magically cleared as soon as a DBCC is run to confirm. We're not getting reports of either of those at this stage.
I read the thread on the Index issue That Tony Blater had, but it doesn't seem to apply 100% in this case...
Any ideas?
Thanks!!!
Dylan
April 22, 2005 at 6:16 am
Are you sure that you don't need domain account in this scenario? As I see you are using NT AUTHORITY\SYSTEM account...
How many servers have you involved in log shipping?
Which server can't take a backup for restore?
Can he copy *.trn to his hard disk?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply