You're taking Gail's comment out of context. Indexes do require periodic rebuilding just as...

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...

freaky

jcrawf02 (7/15/2011)

---

GSquared (7/14/2011)

---

Brandie Tarvin (7/14/2011)

---

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....

I disagree with this advice for reasons stated before this answer was posted.

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...

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...

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...

oxymoron

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....

GilaMonster (7/14/2011)

---

No such blog post.

Maybe you're thinking of this:...

Wait. Initial size is 10GB? What is the file's initial size on the principal server?

I don't think SQL...

mortalic (7/13/2011)

---

Brandie, you keep coming back to the tlog actually needing the space, but from what I can tell there are virtually no transactions occurring right now (one or two...

seth delconte (7/13/2011)

---

Here's a script I use to shrink the t-logs manually if they stretch too big due to failed backups or something:

--try/catch guarantees that shrink log will not happen...

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...