Post reply

Log shipping error

  • May 26, 2010 at 10:08 am

    #235554

    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

    #1173143

    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

    #1173278

    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

    #1246656

    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

    ================================

    Date 11/4/2010 9:33:34 PM

    Log Job History (LSRestore_W2TZDWQC01_GTM2)

    Step ID 1

    Server W2TZDWQC01\INSTANCE2

    Job Name LSRestore_W2TZDWQC01_GTM2

    Step Name Log shipping restore log job step.

    Duration 00:00:01

    Sql Severity 0

    Sql Message ID 0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted 0

    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

    #1247511

    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