New Question Regarding LOG SHIPPING & MASTERDB

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • smyers1972

    New Question Regarding LOG SHIPPING & MASTERDB

    I got log shipping to partially work *lol* any how what my new issue is,
    the masterdb, any good documentation? Ive tried searching google and find
    very little on that matter.

    Thank you


  • smyers1972

    #2
    Re: New Question Regarding LOG SHIPPING & MASTERDB - addition

    I guess I forgot to mention this is SQL 2000 Enterprise.

    Sorry :) and thank you in advance

    Comment

    • johnbandettini@yahoo.co.uk

      #3
      Re: New Question Regarding LOG SHIPPING & MASTERDB - addition

      You don't need to log ship your master database. It should be small
      enough that you can back it up when you need to. Back it up once a day
      and whenever you make changes to your other databases ie add or drop a
      database, change size etc. In most cases your master might go days or
      even weeks without any changes.

      smyers1972 wrote:[color=blue]
      > I guess I forgot to mention this is SQL 2000 Enterprise.
      >
      > Sorry :) and thank you in advance[/color]

      Comment

      • smyers1972

        #4
        Re: New Question Regarding LOG SHIPPING & MASTERDB - addition

        Thank you I will try it out and see if I can restore it... I tried to
        restore it before but had drive location issues i.e. logs were on drive L
        but on the log ship to server they are drive D, i reworked the scheme and
        made them identical to the original box... will see how it goes...
        Thanks!


        Comment

        Working...