Monday, March 19, 2012

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 youI guess I forgot to mention this is SQL 2000 Enterprise.

Sorry :) and thank you in advance|||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:
> I guess I forgot to mention this is SQL 2000 Enterprise.
> Sorry :) and thank you in advance|||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!

No comments:

Post a Comment