[THIN] Re: Way OT. How do I shrink the transaction log in MSSQL7?
- From: "Lilley, Brian" <Brian.Lilley@xxxxxxxxxxxxx>
- To: "'thin@xxxxxxxxxxxxx'" <thin@xxxxxxxxxxxxx>
- Date: Thu, 7 Aug 2003 14:07:55 +0100
I'm sure there is a shrink util which does the business?? there is gallons
of info on MS knowledgebase....
or, you could detach the database so you have a 40MB file, then drop the
database and log, then re-create the database and re-attach file and make
sure you have a maintenance plan to 'truncate' the log or somesuch, I can't
quite remember....
-----Original Message-----
From: Angus Macdonald [mailto:Angus.Macdonald@xxxxxxxxxxxxxxxxxxx]
Sent: 07 August 2003 13:58
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Way OT. How do I shrink the transaction log in MSSQL7?
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
***********************************************************************************
EDF Energy plc internet e-mail disclaimer
This e-mail and any files transmitted with it are confidential and may be
protected by legal privilege.
If you are not the intended recipient, please notify the sender and delete the
e-mail from your system.
This e-mail has been scanned for malicious content but the internet is
inherently insecure and EDF
Energy plc cannot accept any liability for the integrity of this message or its
attachments. No employee
or agent of EDF Energy plc or any related company is authorised to conclude any
binding agreement on
behalf of EDF Energy plc or any related company by e-mail. All e-mails sent and
received by EDF Energy
plc are monitored to ensure compliance with the company's information security
policy.
***********************************************************************************
********************************************************
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:
