...http://msdn.microsoft.com/en-us/library/aa258281(SQL.80).aspx Books Online (BOL) is a SQL Server referance e-encyclopedia. Take advantage of it!: http://msdn2.... I'm a newbie in the SQL world I have to shrink the transaction Log of an SQL 2000 Database So I googled around and found that I ... is there another way to shrink the transaction Logs? and avoid future overload of my ...

Hi I'm a newbie in the SQL world I have to shrink the transaction Log of an SQL 2000 Database So I googled around and found that I have to use the command DBCC SHRINKFILE But I can't find the file DBCC anywhere on my server? Where can I find it or download it? Or is there another way to shrink the transaction Logs? and avoid future overload of my DB due to many transaction logs?

...> how do i find out what process could have caused a transaction log to fill up possibly over hte... independently to multiple newsgroups. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books ...at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online ... Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

...... Hi! We have a Microsoft SQL Server 2000 SP3 running database for Microsoft...query procedures from Navision, with the transaction log. It's actually setup as ... every 1-2-3 months): The log file for database 'ME_Prod' is full. Back up the transaction log for the database to free up some log space.. How do I have to setup my transaction log file in such manner, that ...

... time that the oldest open transaction is complete. Therefore, your push ....7. In the mix, some transaction(s) stay open long enough...course (3) increase your maximum log file space to allow everything...Hi! We have a Microsoft SQL Server 2000 SP3 running database...procedures from Navision, with the transaction log. It's actually setup...1-2-3 months): The log file for database 'ME_Prod' is...

...... Hi! We have a Microsoft SQL Server 2000 SP3 running database for Microsoft...query procedures from Navision, with the transaction log. It's actually setup as ... every 1-2-3 months): The log file for database 'ME_Prod' is full. Back up the transaction log for the database to free up some log space.. How do I have to setup my transaction log file in such manner, that ...

Hi! We have a Microsoft SQL Server 2000 SP3 running database for Microsoft ... heavy query procedures from Navision, with the transaction log. It's actually setup as follows:... (once every 1-2-3 months): The log file for database 'ME_Prod' is full. Back up the transaction log for the database to free up some log space.. How do I have to setup my transaction log file in such manner, that it...

... truncate properly. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Bill ...dump, and the columns about transaction file truncation were 2 and...a problem. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Bill...understand, the purpose of the transaction log is to save actions...

...and truncate properly. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Bill Bradley...or truncated. Even after I added Transaction Log backups, there remained only 50... a problem. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Bill ...(or available freespace of the log file). What do I not ...

...truncate properly. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Bill...produces a heathy amount of log file size, and, it was...truncated. Even after I added Transaction Log backups, there remained only...dump, and the columns about transaction file truncation were 2 and...a problem. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Bill...