[THIN] Way OT. How do I shrink the transaction log in MSSQL7?

  • From: Angus Macdonald <Angus.Macdonald@xxxxxxxxxxxxxxxxxxx>
  • To: thin@xxxxxxxxxxxxx
  • Date: Thu, 7 Aug 2003 13:58:08 +0100

I have a database with 40MB of data and an almost empty 3.9GB transaction
log. How would I go about getting the transaction log file back to a
reasonable size? I've tried dumping it and setting a checkpoint with the
"truncate log on checkpoint" option set, but the physical file remains at
3.9GB.

I don't really want to take the service offline as it's a busy machine but I
will if I have to.

Regards
Angus
********************************************************
This Week's Sponsor - RTO Software / TScale
What's keeping you from getting more from your terminal servers? Did you know, 
in most cases, CPU Utilization IS NOT the single biggest constraint to scaling 
up?! Get this free white paper to understand the real constraints & how to 
overcome them. SAVE MONEY by scaling-up rather than buying more servers.
http://www.rtosoft.com/Enter.asp?ID=147
**********************************************************
Useful Thin Client Computing Links are available at:
http://thethin.net/links.cfm

For Archives, to Unsubscribe, Subscribe or 
set Digest or Vacation mode use the below link:
http://thethin.net/citrixlist.cfm

Other related posts: