... up the database, and then truncate the log, you have broken the log ... whatever you assemble in the transaction log is useless. but my questions is...you don't backup the transaction log. Backing up the database backs up...shrinking a database file. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se ...://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books ...

... works. you should take transaction log backups for that purpose. -- Ekrem...is full as well in SQL. I'm using Symantec Backup...option so it deletes the logs. I thought that If I...why isn't the log files truncating since I'm running...two are related. Simple method: Logs are cut down periodically. Full...make database backups, then the log grows between database backups for...

...mode is full as well in SQL. I'm using Symantec Backup ... up Job it would truncate the logs as well. It sounds ... not be backing up the logs. currently I use Backup Exec ... two are related. Simple method: Logs are cut down periodically. Full ...> b) Full method, database and log backups. Pro: Can recover to ... make database backups, then the log grows between database backups for ...

... a computer-generated report for Log-Facile-0.02 on perl ...'blib/arch')" t/*.t t/Log-Facile....ok All tests successful...usr/local/src/CPAN/build/SQL-Abstract-Limit-0.12-28WngV...usr/local/src/CPAN/build/SQL-Abstract-Limit-0.12-28WngV...usr/local/src/CPAN/build/SQL-Abstract-1.24-kKrX7W/blib...local/src/CPAN/build/String-Truncate-0.102-pgJlfg/blib/arch...local/src/CPAN/build/String-Truncate-0.102-pgJlfg/blib/lib...

... a computer-generated report for Log-Facile-0.02 on perl...blib/arch')" t/*.t t/Log-Facile......ok All tests successful...usr/local/src/CPAN/build/SQL-Abstract-Limit-0.12-Hl9C0m...usr/local/src/CPAN/build/SQL-Abstract-Limit-0.12-Hl9C0m...usr/local/src/CPAN/build/SQL-Abstract-1.24-EAIOuQ/blib...local/src/CPAN/build/String-Truncate-0.102-BGitrv/blib/arch...local/src/CPAN/build/String-Truncate-0.102-BGitrv/blib/lib...

...You can download and use SQL Server Management Studio Express if...Thanks so much "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb...be, but aren't taking log backups for some reason, or...in simple recovery mode, the log will manage itself. Anyway, have...so I want to truncate the logs. I have done this...other programs and the full SQL server before but never on...

...If you reboot the server the log file stops growing but there is...? Thanks so much "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb....> be, but aren't taking log backups for some reason, or (...; in simple recovery mode, the log will manage itself. Anyway, have ... so I want to truncate the logs. I have done this ... other programs and the full SQL server before but never on ...

... computer-generated report for Regexp-Log-WMS-0.02 on perl...arch')" t/*.t t/Regexp-Log-WMS....ok All tests successful...requires: Module Need Have ----------- ---- ---- Regexp::Log 0 0.04 Test::More...local/src/CPAN/build/String-Truncate-0.102-lsJgFv/blib/arch...local/src/CPAN/build/String-Truncate-0.102-lsJgFv/blib/lib...usr/local/src/CPAN/build/SQL-Interpolate-0.33-ZCyafM/blib...

... a computer-generated report for Regexp-Log-RealServer-0.02 on perl 5....'blib/arch')" t/*.t t/Regexp-Log-RealServer....ok All tests successful. ...: requires: Module Need Have ----------- ---- ---- Regexp::Log 0 0.04 Test::More 0...:/usr/local/src/CPAN/build/String-Truncate-0.102-lsJgFv/blib/arch:/usr/...lib:/usr/local/src/CPAN/build/SQL-Interpolate-0.33-ZCyafM/blib/arch...

...a computer-generated report for Regexp-Log-Helix-1.04 on perl 5...: requires: Module Need Have ----------- ---- ---- Regexp::Log 0.04 0.04 ------------------------------ ENVIRONMENT AND...usr/local/src/CPAN/build/Regexp-Log-RealServer-0.02-om0jqn/blib/.../local/src/CPAN/build/String-Truncate-0.102-HkUcij/blib/arch:/...:/usr/local/src/CPAN/build/SQL-KeywordSearch-1.11-ri_eFL/blib/...