Log shipping : why can't I specify multiple files?
I am using log shipping to provide a standby, read-only DB for reporting. Reporting queries are run on a schedule and I adjust the log shipping schedule to not interfere. Unfortunately for some reason my log shipping stops working after about 7 days (the target database gets stuck in permanent "RESTORING" state). So I end up having to re-initialize the log shipping (because it is faster than going back to last week's seed and applying ~700 log files). But sometimes the backup fails as described above, and I have to start over. It would be great if we could have this control in the wizard just like we do in the normal UI and command-line, so I don't have to bypass the wizard.