SQL Server Performance

Log shipping restore problem

Discussion in 'SQL Server Log Shipping' started by yrnath, Jul 15, 2004.

  1. yrnath New Member

    i configer logshipping. logbackups are created every 15 min and copy files to secondary server every 15 min. but not restore. it giving first_file_000000000000.tnr file restore fail. and


    [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4306: [Microsoft][ODBC SQL Server Driver][SQL Server]The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.
    [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.



    this is i am facing problem.


    please give best solution.



    Ranganath

    yrnath
  2. satya Moderator

    Follow as reported :
    The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.

    If not restore the database from primary to secondary server using WITH NORECOVERY and then start log shipping in order to restore the logs.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. Denis Garza New Member

    quote:Originally posted by yrnath

    i configer logshipping. logbackups are created every 15 min and copy files to secondary server every 15 min. but not restore. it giving first_file_000000000000.tnr file restore fail. and


    [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4306: [Microsoft][ODBC SQL Server Driver][SQL Server]The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.
    [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.



    this is i am facing problem.


    please give best solution.



    Ranganath

    yrnath

Share This Page