Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Transaction Logs

Author  Topic 

swoozie
Starting Member

25 Posts

Posted - 2008-04-22 : 13:12:54
We have an access database that is using an ODBC connection to a SQL database to pull in data. When the process runs it creates a transaction log that consists of every millisecond Login/Logoff during the processing. Is this normal? This is making our log files huge and slowing our backups dramatically.

I have not been able to located the information online.



tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-22 : 13:23:05
What do you mean by it creates a transaction log with the login/logoff audits? Explain exactly where you are seeing this.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-22 : 21:51:08
Did you see those in sql server log? If you enabled sql login auditing, that's normal.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-22 : 21:58:00
swoozie,

If you are referring to the SQL Server Error Log as rmiao mentioned, then this wouldn't be impacting your transaction log or backups.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -