Post reply

SQL Server log shipping - structure changes?

  • April 15, 2005 at 9:24 am

    #165263

    I've just started delving into this.

    I've got a wizard do a VERY simple log ship for a test database (VERY SIMPLE - 0 tables [] ) - that is working fine.

    Now I've added my first table - and it seems that my beliefs are correct - i.e. table creation is not an operation than can be re-created via the "log" part of log shipping - a new full backup will be needed. Correct?

    FYI - this is a proof-of-concept (which I need to finish by Wednesday [B)] )at the moment, with the idea being to sue Log Shipping to create a reporting environment, and not a warn-failover environment...

    CiaO 4 now - and have a great weekend

  • April 16, 2005 at 1:40 am

    #553044

    Then you must have a problem in your log shipping setup. Because DDL operations are propagated to a standby server. Without this log shipping would be useless.

  • April 18, 2005 at 3:02 am

    #553094

    Thanks Martin - it definitely seems I've got some kind of problem in the way I set it up - which is kinda strange, given that I just used the wizard...

    Oh well - I'm off to dig for a reason..

    Thanks again

  • April 18, 2005 at 6:22 am

    #553124

    Found my mistake - errors in log shipping UNC directory - Transaction Log backups weren't being found and copied.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply