New Question Regarding LOG SHIPPING & MASTERDB

[smyers1972]

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]

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

[johnbandettini@yahoo.co.uk]

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]

[smyers1972]

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!