Re: Massive Log Files
From: Carlos Eduardo Rojas (carloser_at_mindspring.com)
Date: 03/02/04
- Previous message: Carlos Eduardo Rojas: "Re: Performance Testing: Can I void the cache?"
- In reply to: Jeff Johnson: "Massive Log Files"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 1 Mar 2004 22:31:18 -0500
If you're not backing up the transaction log, use simple recovery model
instead of full (or bulk-logged). To truncate the log, use the BACKUP LOG
command with the TRUNCATE_ONLY option, you can find more info in books
online.
-- Carlos E. Rojas SQL Server MVP Co-Author SQL Server 2000 Programming by Example "Jeff Johnson" <anonymous@discussions.microsoft.com> wrote in message news:2E21167D-7069-4241-AB1C-E518AF0A130A@microsoft.com... > We have a problem with huge log files for our SQL Server databases. > > We can't figure out how to get these files down to a reasonable size. > > We've been digging through Books Online and trying various esoteric commands... but nothing works. > > Any ideas??? Please help!
- Previous message: Carlos Eduardo Rojas: "Re: Performance Testing: Can I void the cache?"
- In reply to: Jeff Johnson: "Massive Log Files"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
