Post reply

Log Shipping, Transaction Logs not being restored (error:14421)

  • January 26, 2010 at 2:00 am

    #218526

    (error:14421)

    I have MSSQL 2008(EE) evaluation and 2 instances

    1) SQL1

    2) SQL2

    Log shipping for the database : LOG_TEST on SQL1, has been enabled.

    I can see the database was initialised in the SQL2 instance. The database is in Standby/Read Only mode. However any updates on SQL1\LOG_TEST cannot be found on SQL2\LOG_TEST. The transaction logs are present in the Secondary instance folder.

    The Logs are being backed up , but no restoration on secondary is happening

    Both instances run on the administrator user accounts.

    Could someone help.

    Thanx in advance

  • January 26, 2010 at 8:44 am

    #1108730

    I had a problem just like this... by any chance are these VMs? Was one a copy of the other? If so, you may need to adjust the entries in master.sys.servers for the copy by using the sp_DropServer and sp_AddServer stored procedures.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • February 8, 2010 at 1:51 am

    #1115325

    Are you seeing any errors in the secondary server log restorign job history




    My Blog: http://dineshasanka.spaces.live.com/

Viewing 3 posts - 1 through 2 (of 2 total)

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