Home Forums SQL Server 2008 SQL Server 2008 High Availability All the 3 jobs are running successfully but Restoration in Secondary server is not happening RE: All the 3 jobs are running successfully but Restoration in Secondary server is not happening

  • Dear Sir ,

    Good Morning..

    Please find the below Message...This is the whole message of Restore Job.

    Message

    2014-04-11 18:25:01.04Could not find a log backup file that could be applied to secondary database 'Secondary'.

    2014-04-14 09:45:01.58The restore operation was successful. Secondary Database: 'Secondary', Number of log backup files restored: 0

    2014-04-14 09:45:01.60Deleting old log backup files. Primary Database: 'Secondary' "

    Note :Secondary is my Name of Secondary Database.

    And one more thing am having doubt sir,

    Here in this Log Shipping while am trying to check the Primary Database Details by using the following Command

    "select * from msdb.dbo.log_shipping_monitor_primary" nothing is displaying, it is showing only the column names..

    Ps help me out..

    Regards

    Jagadeesh...

    Regards
    Chowdary...