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 Development (2000)
 Finding out of old transactions are still active

Author  Topic 

Ex
Posting Yak Master

166 Posts

Posted - 2005-04-03 : 22:08:46
Hi i am trying to do a full backup and my log file doesn't get truncated

just wondering why this would be i had a look at BOL and it says a old transaction is still active but i am having trouble finding out how to work out which transaction is active any ideas?

nr
SQLTeam MVY

12543 Posts

Posted - 2005-04-03 : 22:22:45
full (or diff) backup doesn't truncte log files.
see
http://www.mindsdoor.net/SQLAdmin/TransactionLogFileGrows_1.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -