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.
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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
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. |
|
|
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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|