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

Check the server Event Viewer logs (especially Security) for around that time frame. What do they say?

The connection string would be helpful. Maybe a screenshot of the error as well.

Pretty much.

Is there any improvement...

Koen Verbeeck (7/13/2011)

---

As it can become quite a long binary string, you can also try converting the image to a hash value, which allows easier comparison:

WHERE HASHBYTES('MD5', cast(ImageColumn1 as varbinary(MAX)))

=...

NO!!!!!!! Say it ain't so!!!

We can't have...

Can someone with Image data type experience please double-check my advice on this thread?

http://www.sqlservercentral.com/Forums/Topic1140743-391-1.aspx

First, I recommend changing that Image data type to a VarBinary(MAX) data type. Image is deprecated in SQL Server (has been since 2005) and will go away in a future...

If you put Read Only data on a different file group, you can actually change your backup options to only backup the Read-Write filegroup. However, that changes your recovery strategy...