Update of image data through ADO Recordset trigger SQL trans log?

[sobeit]

Hi,
I need to make sure that the transaction log files will not get full because we'll have many transaction through a day, which will involve an update of image data type column. We'll be using ADO Recordset object to do an update, and while testing I can't figure out if SQL Server is logging the transaction or not.

I have try to use the dbcc traceon(3604) AND dbcc log utilities, but they are not showing me any thing that specifies that the table in mind has had an INSERT operation.
The first question is does SQL log the ADO object's update?
Is there a better way to see the transaction log?

Thanks for your time.

 

[tlbroadbent]

If you have frequent transactions, run frequent transaction log backups which will truncate the log. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[sobeit]

Terry,

Thanks for replying. A frequent transaction log backups will certainly make sure that the log does not get filled up; however, I have to see if having a backup run in the middle of a normal business hour will affect our end users.

Also, I am still don't know whether nor not SQL Server enters a log when an update of image record is made through ADO recordset object.

Thanks.

 

[tlbroadbent]

Doing frequent (say every 30 minutes) transaction backups should have very little impact on users.

Which version of SQL Server are you running? As I understand the documentation, the default when updating image/text columns is non-logged in SQL 7 and depends on the recovery mode used in SQL 2000. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.