Viewing 15 posts - 5,566 through 5,580 (of 9,722 total)
The problem is that as soon as you mention the words "boot camp," every trainer who has a certification boot camp comes out of the woodwork trying to sell you...
July 15, 2011 at 5:33 am
Why do you feel the need to shrink your log file? Are you having serious space issues?
If not, don't obsess about file shrinking. It's not worth the headaches you're about...
July 15, 2011 at 5:26 am
As a matter of fact, we have jobs that restore daily down to our QA server. We don't do every database, but we do the major ones.
These restores serve...
July 14, 2011 at 11:39 am
bopeavy (7/14/2011)
effective communication
oxymoron
July 14, 2011 at 11:31 am
May I just mention that many people in this debate are forgetting that historically speaking, there is a predecessor to paying taxes. It even predates feudalism.
It was called tribute....
July 14, 2011 at 11:28 am
GilaMonster (7/14/2011)
Brandie Tarvin (7/14/2011)
EDIT: Oh, hey! Gail is here! Maybe she can remember what blog post I'm crucifying with my poor memory. @=)
No such blog post.
Maybe you're thinking of this:...
July 14, 2011 at 5:53 am
mortalic (7/13/2011)
It is currently 10GB and the initial size is the same.
Wait. Initial size is 10GB? What is the file's initial size on the principal server?
I don't think SQL...
July 14, 2011 at 5:39 am
mortalic (7/13/2011)
July 14, 2011 at 5:33 am
seth delconte (7/13/2011)
--try/catch guarantees that shrink log will not happen...
July 13, 2011 at 1:06 pm
Stick your File System task into a For Each Loop container. Pass the file name / path down from the For Each Loop to the variable and use the variable...
July 13, 2011 at 12:17 pm
mortalic (7/13/2011)
What else can cause the tlog not to shrink?
The need for the space. Just because the tlog backups are happening doesn't mean the log is going to shrink. There...
July 13, 2011 at 12:14 pm
Have you thought about the idea that it might be auto-disabled / enabled via a job?
Search the text (column name might be "Command") in sysjobsteps and see if you can...
July 13, 2011 at 12:08 pm
I think it's time to call the vendor. It might be an issue with the application itself, especially if they never upgraded it to use SQL 2008, and we can't...
July 13, 2011 at 11:47 am
Thanks for posting your solution, Erik. That will help.
July 13, 2011 at 11:39 am
It occurs to me that I've been assuming your application is an in-house developed app. Is that correct or is this a third party app you're using?
If the former, you...
July 13, 2011 at 11:37 am
Viewing 15 posts - 5,566 through 5,580 (of 9,722 total)