Sorry for the very slow response - for some reason I'm not receiving comment notifications on this article, and I missed these comments.

Firstly, I've now corrected the text with regard...

Is anyone still having problems with reaching the various files? I know that our ftp site was down for a period but it is back up now and the book...

Likewise, I cannot replicate the problem.

If you drop a mail to "editor at simple-talk dot com" (substitute and remove spaces, appropriately) , I'll reply and attach the PDF...

I'm not sure why it's showing up as an FTP link. Sorry about that - I'll fix it.Try: http://www.simple-talk.com/simplepod/SQLServerTacklebox.epub
Cheers,Tony.

All,

The PDF is now also available from the main book page:

http://www.sqlservercentral.com/articles/books/94937/

The code is now available from the URL listed in the book:

http://www.simple-talk.com/RedGateBooks/GrantFritchey_SQLServerExecutionPlans_Code.zip

Apologies again for the slight false start here, but...

All,

Sorry for the false alarm everyone. As Grant says, there was no intent to miselad here; it was just a mistake on our part, for which we apologize. The article...

Hi Bev,

Have you treble-checked :-). I'm pretty sure one of those 399 rows must have a value of 2 (active). As soon as you create a database, some info gets...

Thanks everyone, for the feedback.

Personally, I'd be very surprised if everyone was aware of it, plus the concept of a "force flag" that indicates when certain checks are being...

As I tried to express in the editorial, I guess I initially, and wrongly, had a tendency to see REPLACE as "general purpose" command, whenever restoring over an existing database,...

Andre,

Just stumbled across this post: http://stanleyjohns.wordpress.com/2012/01/09/reading-the-transaction-log-using-fn_dblog-and-fn_dump_dblog/

Talks about how to peek inside a log backup using fn_dump_dblog, which can show you what times are contained within. Completely unsupported and...

One question though: when having to restore to a specific point in time using STOPAT can I trust the "BackupStartDate" column returned by the following code?

That would be an easier...

Hi Megistal,

I'd be interested to learn why you'd like another way to force log truncation, other than temporarily switch the database to SIMPLE? It's true that the techniques you suggest...

My understanding is that the log chain starts at the last full DB backup. So if someone runs a full backup of the DB in the middle of...

Hi Peggy,

Yes, I used .bak for all backup files in the article but as you say, the more common convention, which I should probably have followed, is to use .bak...

Thanks for all the comments and sorry, in turn, for being slow to respond. I've been looking into how quickly we could set up a small wiki area on SQLServerCentral,...