[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