May 26, 2010 at 10:08 am
Every now and again I get the error below when the log shipping restore job runs even though the database is in (Standby / ReadOnly) mode. The error is only intermittent and so on the next restore it could work fine.
Any ideas?
Cheers,
Dale
Error: The restore operation cannot proceed because the secondary database 'MyDatabase' is not in NORECOVERY/STANDBY mode.(Microsoft.SqlServer.Management.LogShipping)
May 27, 2010 at 1:18 am
Hi,
Hi,
While Configure the secondary database settings.. You should select
either NoRecovery Mode/Standby mode. Because if you select norecovery mode,
sqlserver will understand to restore an other continous backups.In this mode, you are not able
to view the database.
If you select stand by mode,sqlserver will understand to restore an other continous backups. In this mode, you are able to view the database.
you should check it for the disconnected users in the databases when restoring backups.
if it's uncheck for this option, while restoring error will occurred.
Thanks & Regards
Balaji.G
May 27, 2010 at 6:42 am
Hi Balaji,
Thanks for the reply.
I have Standby Mode selected, and I have also selected Disconnect users in the database when restoring backups.
November 4, 2010 at 10:10 am
Hello Guys
I am still facing the same issue. The restore job in the Secondary Server is failing with the error.
==========================
The restore operation cannot proceed because the secondary database 'GTM_LS' is not in NORECOVERY/STANDBY mode.(
==============================
But, I checked again and found that I set as 'stand by' with Disconnect users while restore option.
Where is the error?????? Pls assist
================================
Date11/4/2010 9:33:34 PM
LogJob History (LSRestore_W2TZDWQC01_GTM2)
Step ID1
ServerW2TZDWQC01\INSTANCE2
Job NameLSRestore_W2TZDWQC01_GTM2
Step NameLog shipping restore log job step.
Duration00:00:01
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
2010-11-04 21:33:35.08*** Error: The restore operation cannot proceed because the secondary database 'GTM_LS' is not in NORECOVERY/STANDBY mode.(Microsoft.SqlServer.Management.LogShipping) ***
Thanks.
November 7, 2010 at 10:49 pm
I think someone has made the database online with following command
RESTORE <database> WITH RECOVERY
Check the SQL Server log for following message:
Restore is complete on database 'database'. The database is now available.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply