[thelist] Truncating Transaction Logs SQL Server 2000

Ken Schaefer Ken at adOpenStatic.com
Mon Apr 17 08:03:25 CDT 2006


Backing up and truncating the transaction log is detailed, quite extensively,
in both the SQL Server 2000 and 2005 documentation. You just need to RTM.

Cheers
Ken

:  -----Original Message-----
:  From: thelist-bounces at lists.evolt.org [mailto:thelist-
:  bounces at lists.evolt.org] On Behalf Of Rob Smith
:  Subject: [thelist] Truncating Transaction Logs SQL Server 2000
:  Importance: High
:  
:  I hope this is a question for thelist.
:  
:  Our transaction log file has reach 11GB and our server is about 600 MB
:  from filling up, thus halting business. How can I truncate, shrink, or
:  otherwise reduce the filesize? Is it possible to just create a new
:  transaction log, and move the 11GB version off to some separate
:  storage as a back up?




More information about the thelist mailing list