Ignite Realtime: Openfire with MS-SQL as Database

Skip navigation

Up to Discussions in Openfire Support

7616 Views 6 Replies Latest reply: May 6, 2010 12:59 PM by Tony Ruggieri

radicalx

42 posts since
Apr 26, 2008

Currently Being Moderated

May 18, 2008 8:05 PM

Openfire with MS-SQL as Database - I Beg for Helped

Hello people.. i just want information on how database works using ms-sql as backend of openfire database. its been 30 days since my last installation of openfire and got 300+ users on it. my problem is when i saw my server drive C space i got a low disk space prompt when i saw it (See Attached file). 13gig.+ i have a daily backup settings on my sql 2000. and i enabled archive loging of messages full.

Any of you got an advised on how to limit the .LDF extension of the database? i hope you can help me here....

Thank you so much People...

Attachments:

openfire.JPG (95.8 K)

Like (0)

bugmenotuser
77 posts since
Aug 16, 2006

Currently Being Moderated

May 19, 2008 6:30 AM (in response to radicalx)
Re: Openfire with MS-SQL as Database - I Beg for Helped

Use this script to shrink your log files.
Sometimes you have to run in twice to reduce the log size.

Attachments:

shrink.sql (2.1 K)

Report Abuse

Like (0)
- radicalx
  42 posts since
  Apr 26, 2008
  
  Currently Being Moderated
  
  May 24, 2008 6:30 PM (in response to bugmenotuser)
  Re: Openfire with MS-SQL as Database - I Beg for Helped
  
  Thanks for the script .. i review the script and i think its helpfull. but i have a another way around in MS-SQL server 2000 theres a shrink features there but im not using it i manage to adjust the option to disabled grow file something like that and delete the database and restore the backup i still got the 13gig log but it didnt grow anymore.. i dont know.. what happen...
  
  Report Abuse
  
  Like (0)
- Thomas Deliduka
  48 posts since
  Sep 20, 2007
  
  Currently Being Moderated
  
  Jul 28, 2008 9:36 AM (in response to bugmenotuser)
  Re: Openfire with MS-SQL as Database - I Beg for Helped
  
  This script didn't work for me. At least it didn't think there was anything to do:
  
  ---------
  Original Size of openfire LOG is 5411408 8K pages or 42276MB
  Final Size of openfire LOG is 5411408 8K pages or 42276MB
  ---------
  
  I really would like to get this thing reduced!! Anyone out there can help?
  
  Report Abuse
  
  Like (0)
Thomas Deliduka
48 posts since
Sep 20, 2007

Currently Being Moderated

Jul 28, 2008 9:25 AM (in response to radicalx)
Re: Openfire with MS-SQL as Database - I Beg for Helped

I have a 43GB log file on my system. I'm currently running the script in question. I hope it works. It seems pretty strange that such a simple application would suck up so many resources.

My big question is would it be advantageous to limit the log file once it's shrunk or will that cause problems?

Report Abuse

Like (0)
Thomas Deliduka
48 posts since
Sep 20, 2007

Currently Being Moderated

Jul 28, 2008 9:40 AM (in response to radicalx)
Re: Openfire with MS-SQL as Database - I Beg for Helped

I spoke too soon!

I changed the recovery mode from "Full" To "Simple" on the options tab of the database. The log file immediately went to 1MB. I can't imagine there is anything in the database that is so important I can't simply use a normal backup to restore from the last night's backup.

Report Abuse

Like (0)
- Tony Ruggieri
  14 posts since
  Jul 9, 2008
  
  Currently Being Moderated
  
  May 6, 2010 12:59 PM (in response to Thomas Deliduka)
  Re: Openfire with MS-SQL as Database - I Beg for Helped
  
  Changing the model from Full to simple did not shrink the transaction log for me. It looks like it is still growing.
  
  TR
  
  Report Abuse
  
  Like (0)

Go to original post

Legend

Correct Answers - 10 points
Helpful Answers - 5 points

May 18, 2008 8:05 PM

Openfire with MS-SQL as Database - I Beg for Helped

Actions

More Like This

Bookmarked By (0)

Legend