Your code is definitely simpler. But the performance (at least on my machine) is lacking. I just stopped it after letting it run for 10 minutes. My table has about...

Thanks for all the tips! I came up with a multi-step solution that so far seems to get me what I need, and I'm happy to share. I'll do a...

Alright, after much more experimentation, it turns out that what I'm trying to do *can* work, provided that the formatting of the log backup file names exactly matches what log...

You are correct, but the metadata is all there. I populated it with the log shipping stored procedures as detailed in BOL:

http://technet.microsoft.com/en-us/library/ms188708(v=sql.105).aspx

If the metadata wasn't there, nothing would work at...

Because this is not true log shipping. I have no control over the primary server - it belongs to the vendor and I can't touch it. Instead, they are sending...

Good point, Steve.

Actually I busted out Process Monitor yesterday to see how it was scanning the log files in the directory and found out that file names do matter -...

I'd say this behavior is pretty consistent - I have re-restored the full backup 4-5 times and have the same behavior each time.

Good question. This is a new setup so no it has never worked before (because it has never been attempted). However I can successfully restore the log backups manually, so...

Hi Jim,

A differential backup contains all the changes made since the last full backup.

In your case, if you are taking a full backup and then rebuilding the indexes afterwards,...

Hi Inder,

The short answer is no, you cannot natively restore a single table. Without a third-party tool your best bet is probably to restore the database somewhere else and copy...

Probably the easiest option (if possible) is for the offsite backups to be copied off the NAS you're already using, so you don't have to create extra backups.

If that's not...

I'd say the absolute worst-case for data loss would be 15 minutes, but that's assuming that the transaction log is totally destroyed and unable to be recovered, and your log...

To me, the advantage of Maintenence Plans is that they're easy - especially for people who need to get maintenance tasks done but don't know how to write T-SQL (think...

I'm not aware of any views or SPs that expose this information - I've only ever seen examples using the tables.

I of course can't guarantee anything, but given that...

Probably the easiest way is to look at the physical_device_name column of the msdb.dbo.backupmediafamily system table. This table contains an entry for each backup, and with some joins to other...