Thanks for the info Michiel. That is very helpful. Daniel From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Michiel Beijen Sent: Thursday, February 03, 2011 1:38 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] OTRS backups We have customers with a wide variety of database sizes; and of course it really depends on the amount of attachments you store. If you store lots of attachments you can also save them outside of the database if you wish. And you should not necessarily start with that, you can do that later on as well. I've seen one customer with 500,000 tickets and 18 GB database size; that's 36kB per ticket on average. And I've seen one customer with 1,500 tickets and 5GB database size; that's > 3MB per ticket on average! So it depends very much on the way you use OTRS. And of course if you have a large CMDB or knowledge base, you should take that into account as well. -- Mike On Thu, Feb 3, 2011 at 1:52 AM, Gerald Young mailto:crythias@gmail.com> wrote: I'm sure it depends on attachments. Text only probably won't grow fast, but thousands of tickets with 1MB attachments... On Wed, Feb 2, 2011 at 7:29 PM, Navarro, Daniel mailto:Daniel.Navarro@gtech.com> wrote: Anyone doing OTRS backups have any estimates about how big they get (obviously depending on usage)? We will be doing the OTRS backup script that comes with the installation package and shipping the dumps to our Backup Data Center location. I've just installed it and done my first backup. Obviously it's not that big but I'm wondering how big it might be a year or two from now. Thanks, Daniel CONFIDENTIALITY NOTICE: The contents of this email are confidential and for the exclusive use of the intended recipient. If you receive this email in error, please delete it from your system immediately and notify us either by email, telephone or fax. You should not copy, forward, or otherwise disclose the content of the email. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs CONFIDENTIALITY NOTICE: The contents of this email are confidential and for the exclusive use of the intended recipient. If you receive this email in error, please delete it from your system immediately and notify us either by email, telephone or fax. You should not copy, forward, or otherwise disclose the content of the email.

Dear Amit, with that amount of attachment data you certainly consider to switsch the storage module to ArticleStorageFS. In the $OTRS_HOME/bin/ directory you will find a script to move the existing attachments form DB to FS. Cheers, Nils On 05.02.2011, at 11:55, Amit Sharma wrote:

It all depends on attachments!!

I am into 8th month of OTRS usage and my DB is 19GB.

Thanks and Regards, Amit Sharma

--- On Thu, 3/2/11, Navarro, Daniel wrote:

From: Navarro, Daniel Subject: [otrs] OTRS backups To: "User questions and discussions about OTRS." Date: Thursday, 3 February, 2011, 5:59 AM

Anyone doing OTRS backups have any estimates about how big they get (obviously depending on usage)? We will be doing the OTRS backup script that comes with the installation package and shipping the dumps to our Backup Data Center location. I’ve just installed it and done my first backup. Obviously it’s not that big but I’m wondering how big it might be a year or two from now.

Thanks,

Daniel

CONFIDENTIALITY NOTICE: The contents of this email are confidential and for the exclusive use of the intended recipient. If you receive this email in error, please delete it from your system immediately and notify us either by email, telephone or fax. You should not copy, forward, or otherwise disclose the content of the email. -----Inline Attachment Follows-----

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

— Nils Leideck Senior Consultant http://webint.cryptonode.de / a Fractal project