Question about Log Shipping + FTP + Restore...
I have a backup scheme which works well, running a full backup and differential backup daily, plus a log file backup hourly. Now I want to try using log shipping to take these transaction logs and synchronize to an offsite database.
I found that I can take my full 4Gig backup offsite via FTP and manually apply the transaction logs to them without any problem. When I tried to automate this, I used the "sqlbackup" command (as per http://www.yohz.com/logship.html) and pointed it to the directory containing the log files. Unfortunately, it doesn't seem to be able to tell which log files have been applied and which ones haven't---it assumes you're just submitting the unapplied transaction log files. So it seems like I need to write some sort of script to figure out which files need to be passed to "sqlbackup" from the big mess of LOG files that I'm synching off the server. (I know that I can use MOVETO, but this creates some problems with our FTP-synching routine, which is only smart enough to download anything which exists on our database server but not the backup server.)
So my question is: is there an easy way of taking a directory full of maybe 70 transaction logs files, and figuring out which 24 need to be applied to sqlbackup before I try to write an ugly script to do it? (For example, is there a way to get the "last applied" log file timestamp, and then figure out from that what new TX log files there are?)