[THIN] Re: Way OT. How do I shrink the transaction log in MSS QL7?
- From: "Magnus" <magnus@xxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Thu, 7 Aug 2003 13:31:30 -0400
You can manulally trunc the log file in query analyzer
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf
Of Angus Macdonald
Sent: Thursday, August 07, 2003 9:39 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Way OT. How do I shrink the transaction log in MSS QL7?
Thanks for that. I'll look into a maintenance plan.
I eventually found the DBCC SHRINKFILE command, which claims to have worked
although it can take some time for the file to actually shrink. I've just
realised I've been poring over an MSSQL6.5 book, which doesn't have this
particular DBCC command. Typical.
-----Original Message-----
From: Lilley, Brian [mailto:Brian.Lilley@xxxxxxxxxxxxx]
Sent: 07 August 2003 14:22
To: 'thin@xxxxxxxxxxxxx'
Subject: [THIN] Re: Way OT. How do I shrink the transaction log in MSS QL7?
you should have a 'maintenance plan' within SQL server itself, this backs
the database up to yet another file, it should be this file that you backup.
within the maintenance plan, there is an option to also backup the
transaction log, and I think it is this that stops it from growing.
also, you can limit the size the log can grow to, but this will cause a
problem if you hit the size limit, i.e. your maintenance plan is not cutting
the transaction log away....
-----Original Message-----
From: Angus Macdonald [mailto:Angus.Macdonald@xxxxxxxxxxxxxxxxxxx]
Sent: 07 August 2003 14:20
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Way OT. How do I shrink the transaction log in MSS QL7?
It's backed up to a remote server using Veritas Backup Exec. The backup
seems to be working properly.
-----Original Message-----
From: Ron Oglesby [mailto:roglesby@xxxxxxxxxxxx]
Sent: 07 August 2003 14:04
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Way OT. How do I shrink the transaction log in MSSQL7?
Is the DB getting backed up by SQL. The transaction logs generally continue
to grow when a backup is not running.
Ron Oglesby
Senior Technical Architect
RapidApp
Office 312.372.7188
Mobile 815.325.7618
email roglesby@xxxxxxxxxxxx
-----Original Message-----
From: Angus Macdonald [mailto:Angus.Macdonald@xxxxxxxxxxxxxxxxxxx]
Sent: Thursday, August 07, 2003 7:58 AM
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
********************************************************
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
********************************************************
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
********************************************************
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
********************************************************
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:
