Viewing 15 posts - 6,241 through 6,255 (of 9,715 total)
jcrawf02 (3/22/2011)
After reading that thread, I want cookies. Thanks a lot, Brandie.
Hee. I am so evil. @=)
March 23, 2011 at 5:00 am
You're welcome. I hope the analogy made things easier to understand for you.
March 22, 2011 at 12:43 pm
Sachin Nandanwar (3/22/2011)
Brandie Tarvin (3/22/2011)
A checkpoint doesn't change the size of the log files. It just marks a section of the log as ready to be reused by the transaction...
March 22, 2011 at 12:34 pm
Sachin Nandanwar (3/22/2011)
GilaMonster (3/22/2011)
Sachin Nandanwar (3/22/2011)
Do shrinking of database logged even though the recovery model is SIMPLE ?All data modifications are logged regardless of the recovery model.
So when a checkpoint...
March 22, 2011 at 12:17 pm
GilaMonster (3/22/2011)
Sachin Nandanwar (3/22/2011)
Do shrinking of database logged even though the recovery model is SIMPLE ?All data modifications are logged regardless of the recovery model.
Hence the reason, Sachin, why I...
March 22, 2011 at 11:54 am
Jason, you need to change that out for the image of Boo in her monster costume. @=)
March 22, 2011 at 11:51 am
Oh, hey, completely non-SQL related link:
If you like superheroes, you will like "Grayson" (They created this trailer with an 18,000 dollar budget).
March 22, 2011 at 11:39 am
GilaMonster (3/22/2011)
Brandie Tarvin (3/22/2011)
March 22, 2011 at 11:38 am
Sachin Nandanwar (3/22/2011)
mail.pnreddy (3/21/2011)
Here are the steps i followed.
Change the DB back to Simple If it is in Full mode.
Change it back to Full mode.
Use...
March 22, 2011 at 11:20 am
GSquared (3/22/2011)
Brandie Tarvin (3/22/2011)
March 22, 2011 at 11:12 am
<groan> Why oh why do the same "bad" solutions keep popping up when there are tons and tons and tons of articles telling people why it's a bad idea to...
March 22, 2011 at 10:23 am
mail.pnreddy (3/22/2011)
You are correct. But when there is no disk space even to perform a full/diff backup how would you handle that?
Do you have another disk drive handy?
Have...
March 22, 2011 at 10:19 am
Glad we could help. Mind posting your solution in case anyone has a similar issue?
March 22, 2011 at 5:54 am
Wow. I am seriously brain-dead today that I didn't see that solution.
Thanks, Lutz. Sometimes it just takes a second set of eyes. I've been looking at this code for too...
March 21, 2011 at 12:34 pm
GilaMonster (3/21/2011)
Minimally logged operations
Ah, yes. Ye good ol' bulk insert or BCP.
March 21, 2011 at 9:00 am
Viewing 15 posts - 6,241 through 6,255 (of 9,715 total)