SQL Server Performance

Log shipping problem

Discussion in 'SQL Server Log Shipping' started by mgole, Feb 2, 2005.

  1. mgole New Member

    Hi

    I while configuring log shipping, if i choose the "allow database to assume primary role" then the "ceate and initialise new database " option selected by default..Does this happen all the time or am i missing something.

    Thanks

    Madhukar Gole
  2. satya Moderator

    Yes whenever the new database is created then it will initialise the data files defined.
    And it will not have any negativ imapct, as such.

    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. mgole New Member

    When i configure log shipping with the "allow database to assume primary role" option..the wizard hangs and does not respond.Without using this option the log shipping works fine.Also there is no error message in the server logs.

    Thanks

    Madhukar
  4. satya Moderator

    Check event viewer for any information on hardware and you will also need to specify the share in which transaction log backups from the secondary server will be stored.

    So its better to check both PRIMARY and SECONDARY servers for any information.
    And also PROFILER to see under-blanket operations.

    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.

Share This Page