Re: [otrs] OTRS backups

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.