Viewing 15 posts - 1 through 15 (of 52 total)
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...
April 12, 2013 at 8:56 am
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...
March 31, 2013 at 11:21 am
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...
January 14, 2013 at 11:13 am
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.epubCheers,Tony.
January 11, 2013 at 9:01 am
The PDF is now also available from the main book page:
The code is now available from the URL listed in the book:
Apologies again for the slight false start here, but...
December 7, 2012 at 10:25 am
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...
December 5, 2012 at 7:46 am
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...
November 30, 2012 at 9:20 am
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...
April 2, 2012 at 10:48 am
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,...
April 1, 2012 at 4:51 am
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...
January 31, 2012 at 5:23 am
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...
January 31, 2012 at 5:10 am
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...
January 30, 2012 at 4:48 am
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...
January 30, 2012 at 4:13 am
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...
January 30, 2012 at 3:56 am
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,...
October 6, 2011 at 8:35 am