Viewing 15 posts - 541 through 555 (of 832 total)
Rune Bivrin (3/11/2011)
This question is just completely broken. There's a big difference between "preferred" and "valid". And to claim that varbinary(max) isn't a LOB is a bit daft.
QFT. Not to...
March 11, 2011 at 2:12 am
To be honest I think my jaw dropped when Steve said his *laptop* has 16Gb of RAM in it! I can only dream of having hardware like that available--we upgraded...
March 11, 2011 at 2:07 am
This is odd. I'm sure I've read stuff that implies TRUNCATE TABLE *does* invalidate log backups until the next full backup is run, which means none of the suggested answers...
March 9, 2011 at 3:24 am
Hmmmm. If it hadn't linked the Wikipedia article I got the wrong answer of 2 from I'd have been fine, but when the reference quoted in the real answer supports...
March 4, 2011 at 6:44 am
I agree with Kermit--does this technique offer any benefits over just using full-text search? You can even get SQL Express with full-text search capabilities now!
February 28, 2011 at 1:37 am
He already did post his solution--read the second post.
February 24, 2011 at 6:16 am
TheSQLGuru (2/22/2011)
It is amazing that 9GB of disk space is a problem these days. You can fit that on a USB key now! 😀
While true, I'm really not sure...
February 23, 2011 at 3:35 am
As far as I know they don't delete old topics on this site...if people would stop re-activating them by posting in them it might help stop them coming to everyone's...
February 23, 2011 at 3:15 am
I picked a random answer because I was interested to see what the actual answer was...interesting to know!
February 23, 2011 at 3:12 am
Silly question: this 0006 date isn't supposed to be 2006, is it? Would be a lot easier to handle if that's the case.
February 22, 2011 at 1:41 am
Yes, it *can* get back into sync automatically. The only reason it would not do that is if one of the log file backups was lost. Once that big log...
February 18, 2011 at 6:21 am
Doesn't sound like a very long time to me. What's the speed of the link this backup file is being copied over?
February 18, 2011 at 6:09 am
When you say your log shipping is going out of sync, how long are you leaving it for? We have log shipping set up over an ADSL link (e.g. really...
February 18, 2011 at 2:38 am
Viewing 15 posts - 541 through 555 (of 832 total)