Log Shipping Error

  • Hello,

    I am new to log shipping. i have 2 sql instances in my computer and tried log shipping but the restore job fails every time with following message. i restored the DB in no recovery state and restore LS using Standby mode with disconnected user"

    am i missing anything. kindly help

    "12/16/2011 10:20:00,LSRestore_SUVITHA_AdventureWorks,Error,1,SUVITHA\INST1,LSRestore_SUVITHA_AdventureWorks,Log shipping restore log job step.,,Executed as user: SUVITHA\SYSTEM. The step failed.,00:00:03,0,0,,,,0

    12/16/2011 10:20:00,LSRestore_SUVITHA_AdventureWorks,Unknown,1,SUVITHA\INST1,LSRestore_SUVITHA_AdventureWorks,Log shipping restore log job step.,,2011-12-16 10:20:03.59*** Error: The restore operation cannot proceed because the secondary database 'AdventureWorks' is not in NORECOVERY/STANDBY mode.(Microsoft.SqlServer.Management.LogShipping) ***<nl/>2011-12-16 10:20:03.62Deleting old log backup files. Primary Database: 'AdventureWorks'<nl/>2011-12-16 10:20:03.62The restore operation completed with errors. Secondary ID: '3fb8605f-6027-496a-822c-ddbf932a57a5'<nl/>2011-12-16 10:20:03.62----- END OF TRANSACTION LOG RESTORE -----<nl/><nl/>Exit Status: 1 (Error),00:00:03,0,0,,,,0"

    Regards
    Durai Nagarajan

  • Are you sure the secondary db is in norecovery mode? the error information indicates that it is not in norecovery mode. Can you take a screenshot of the database in object explorer and attach it..


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • The errors are pretty clear. The restored database is not in recoverymode/standby mode.

    Can you confirm the following

    1) Your primary db (Source db) is in the full recovery mode.

    2) Your restored database on the target in the recoverymode/standby mode.

    Babu

  • baabhu (12/15/2011)


    The errors are pretty clear. The restored database is not in recoverymode/standby mode.

    Can you confirm the following

    1) Your primary db (Source db) is in the full recovery mode.

    How will log backups be possible if the primary db is not in full/bulk-logged recovery mode?

    His restore jobs are failing, not the log backup jobs..


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • My Bad. Yes the transaction log backup is happening. Thanks Bru.

    Sorry about that.

  • Bru,

    object explorer? is it there on SQL 2005, if it is, how will i find it.

    or are you talking about Database properties -> options or other.

    Regards
    Durai Nagarajan

  • durai nagarajan (12/16/2011)


    Bru,

    object explorer? is it there on SQL 2005, if it is, how will i find it.

    Object explorer is the pane in left hand side of the SQL Server Management Studio, where you see the list of databases. take a screenshot of that showing the databases on your secondary server.


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • Bru,

    thanks and screenshot attached.

    Regards
    Durai Nagarajan

  • Looking at the attachment your database adventureworks on the secondary server is not under no recovery mode. Let us know how did you get the adventurework database on the secondary server. Please share the t-sql if you have any or the steps you followed.

  • durai nagarajan (12/18/2011)


    Bru,

    thanks and screenshot attached.

    Hi,

    As I guessed the secondary database is not in norecovery mode. There must have been a recovery done by mistake in your previous steps. I would suggest you restart the entire process of setting up the secondary database..


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • Bru,

    Can i know how you have identified it.

    i'll certainly do the process again.

    Regards
    Durai Nagarajan

  • Bru,

    It is working and i have found out how the database is in NoRecovery mode.

    Thanks for your help.

    Regards
    Durai Nagarajan

  • durai nagarajan (12/18/2011)


    Bru,

    It is working and i have found out how the database is in NoRecovery mode.

    Thanks for your help.

    You are welcome...


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • Hello,

    Is there any other way (other than logfile name in restore job) to confirm the restoration.

    Regards
    Durai Nagarajan

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply