February 18, 2009 at 9:04 pm
Hi all,
One of my standby sql server database I am not able to apply transaction logs. Till yesterday night I had applied transaction logs and database was on Loading status and today morning it was changed to normal.
While applying transaction logs manually, I got the below error.
Server: Msg 4306, Level 16, State 1, Line 1
The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
In ERRORLOG i got the last message as below:
Using 'xplog70.dll' version '2000.80.2039' to execute extended stored procedure 'xp_msver'.
Please tell me how to find when the database opened and solution to make it again standby mode.
Thanks
Pratheep
February 18, 2009 at 10:59 pm
the last tran log file was restored without norecovery/standby clause.
You'll need to restore the latest full backup from your production( in norecovery/standby mode) and then apply succeeding tran log backups.
Looks like log shipping... isn't automated?
February 19, 2009 at 1:37 am
n.pratheep (2/18/2009)
Please tell me how to find when the database opened and solution to make it again standby mode.
Restore the latest full, with NORECOVERY or STANDBY option, and then restore all logs up until the latest with the same option.
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
February 19, 2009 at 7:05 am
You need to start a fresh for best result in your case. First restore the latest Full Backup files recovery as a base and then if any latest Diffrential Backup files and then after the subsequent Transaction Log files.
You have to restore a full backup with the option no recovery / standby as a base (so it doesn't rollback incomplete transactions and additional restores can be done). After that you can apply differential backups / transaction logs with the norecovery / standby options.
Only when you no longer need to apply additional restores you can use RESTORE DATABASE X WITH RECOVERY.
February 20, 2009 at 3:47 am
Thanks all your replies. I have restored full backup and started again applying transaction logs.
But am not able to traceout how & when the standby database got open normal status. In error log and restorehistory table showing last log applied with with standby option only.
Only thing am suspecting is before applying transactions logs we have installed some security patches in server.
Regards,
Pratheep.
February 20, 2009 at 4:21 am
This is strange. The database does not online in such a case. Did you check with detailed activity logs ?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply