+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, Shrink SQL Log Files - SIMS, FMS, Discover - ShrinkDBLog.bat in Technical; If you read KB104766 on supportnet and wanted to shrink the log files for any of your databases (our Discover ...
  1. #1
    Ben-BSH's Avatar
    Join Date
    Jun 2009
    Location
    UK
    Posts
    200
    Thank Post
    88
    Thanked 30 Times in 22 Posts
    Rep Power
    21

    Shrink SQL Log Files - SIMS, FMS, Discover - ShrinkDBLog.bat

    If you read KB104766 on supportnet and wanted to shrink the log files for any of your databases (our Discover log was rather large) here is the batch file the supportnet article mentions, save you grabbing it from Capita, remember to edit the PW for the SA account in the file. worked a charm for us! reduced the resource load on our server loads, and the log file down to 1mb!

    Hopefully Capita don't mind it being here

    ShrinkDBLog.zip

    Ben.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,970
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Just be warned that it alters your recovery mode to simple, so could affect your backups, and restores, if you deliberately keep it in FULL mode.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 2
    Last Post: 10th December 2007, 10:30 AM
  2. SQL 2005 and SIMS FMS Finance
    By thom in forum MIS Systems
    Replies: 2
    Last Post: 30th August 2007, 04:50 PM
  3. Replies: 3
    Last Post: 9th September 2006, 08:13 PM
  4. Wanted: SIMS FMS & Fees Ledger Guru
    By pete in forum MIS Systems
    Replies: 0
    Last Post: 22nd May 2006, 09:05 AM
  5. SIMS Database & Log File
    By indiegirl in forum MIS Systems
    Replies: 14
    Last Post: 17th March 2006, 03:00 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •