SQL Server Performance


Discussion in 'SQL Server Log Shipping' started by RAJENDRA, Jul 13, 2005.

  1. RAJENDRA New Member

    Is it possible to set log shipping to master database ?if Yes how? if not why ?

  2. surendrakalekar New Member

    Don't post your question more than once.

    Surendra Kalekar

  3. deepakontheweb New Member

    Well, MASTER database remain in simple recovery model. thatsfore logshipping is not aplicalble for it.(there could be other reasons also..like its a system database not user)

    Do you seriously require to set log shipping for MASTER database???? why do you want this..may be someother process can help you instead of logshipping.

    Deepak Kumar

    --An eye for an eye and everyone shall be blind
  4. satya Moderator

    No only user databases which are not in SIMPLE recovery model can be get under log shipping schedule.

    You can continue taking full backup for system databases and copy it in another server for contingency purposes.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page