April 15, 2005 at 9:24 am
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
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
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
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