Viewing 15 posts - 5,566 through 5,580 (of 9,726 total)
Ditto to what Gail said. Do not shrink your data file.
You need to reevaluate your entire mirrored server set up. Why is it chewing up space when your primary server...
July 15, 2011 at 10:40 am
jcrawf02 (7/15/2011)
GSquared (7/14/2011)
Brandie Tarvin (7/14/2011)
July 15, 2011 at 6:57 am
Jayanth_Kurup (7/15/2011)
Run checkpoint and then try doing a shrink file
I disagree with this advice for reasons stated before this answer was posted.
July 15, 2011 at 5:42 am
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
Viewing 15 posts - 5,566 through 5,580 (of 9,726 total)