[doc] OFF TOPIC: Question About Microsoft SQL Transaction Log......
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[doc] OFF TOPIC: Question About Microsoft SQL Transaction Log......
- From: Nick Tomlinson <nickandkathryntomlinson@xxxxxxxxxxx>
- Date: Fri, 2 Dec 2005 12:58:15 +0000 (GMT)
To computer geeks !
Can anyone help me with an issue I have with Microsoft SQL Server 2000 service pack 3 ?
I have an industrial system that obtains data from SQL where I have data replicated to my SCADA PC (via my router to France) which I query to obtain data from SAP for product runs for starting conditions on the main conveyoy tracking PLC.
Now, this thing is all working hunky dory through all my routing and firewall configurations, but the Microsoft SQL transaction log on my database has grown rapidly over the last 3 months from 4Mb to 12Gb !
I have tried shrinking this database down through MS SQL Enterprise Manager but to no avail. The other MS Technet articles are a bit vague on this subject.
Removing this log and re-starting MS SQL (to try and invoke a new log), makes SQL not work correctly so I have had to go back.
Luckily I specified a large enough raid 5 disk container on the dell server for historical trend growth so I estimate I've got 3 months logging to go but I would rather keep this log file as small as possible.
Any suggestions as to how I can make this log smaller?
I don't mind implementing a SQL Script to run periodically to perform this task but I am unsure how to do this.
Sorry this sounds too boring...........
Thanks in advance,
NickT.
---------------------------------
To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre.
[Non-text portions of this message have been removed]
DOC UK Website: www.deloreans.co.uk
Unsubscribe: doc-uk-unsubscribe@xxxxxxxxxxxxxxx
** Unless otherwise stated, all messages posted to the group are assumed public and may be printed in the club magazine **
SPONSORED LINKS
YAHOO! GROUPS LINKS
Back to the Home of PROJECT VIXEN