Our Log Shipping Primary is running short of space. We intend to allocate another LUN slice to accomodate growth.
Now... our options appear to be:
- moving the Primary dB to the new LUN
- adding another datafile and placing it on the new LUN
The question is... what will happen on the Log Shipped Secondary after we do either of these? Will it try to move the dB to a new location (which won't exist), will it try to add an additional datafile (in a location that won't exist) or will it just continue on its merry way with the existing files as they are today?
Or even worse... will the Secondary have to be re-initialized? That's 100s of GBs over a small pipe - not good.