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

The need for the space. Just because the tlog backups are happening doesn't mean the log is going to shrink. There...

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

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

Thanks for posting your solution, Erik. That will help.

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

SVR (7/13/2011)

---

It is SQL server 2008. The application is installed on the server it is trying to access. Using a system DSN to connect to the db. And the system...

Glad I could help.

Buzz