ISTech Support Forum - ROUTINE MAINT

Welcome, Guest. Please Login.

	05/25/25 at 10:49:14 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › System Manager

‹ Previous topic | Next topic ›

Pages: 1

ROUTINE MAINT (Read 1178 times)

RAGINE

Full Member

I love YaBB 1G -
SP1!

Posts: 150
Gender: female

ROUTINE MAINT
11/02/06 at 08:10:28

Is there any suggested routine data base maint that others are doing? Also can any of the temp files be safely deleted? I do a full backup of the default folder on Monday & an incremental backup the rest of the week, it's gotten to the point where my monday backup is to large for the CD-R 700 MB disc so i have to manualy do that that backup rather than letting it run at night. Any suggestions...PLEASE?

Ragine Hendrickson
Manufacturing Systems Inc/TRU-CATCH TRAPS
ISTECH 2004.1 10/31/06 UPDATE

IP Logged

JNAPIER

Active Member

Evil-Evo Bad Dog!

Posts: 533
Gender: male

Re: ROUTINE MAINT
Reply #1 - 11/02/06 at 10:36:42

Are you using a data compression utility on your data. These file types compress really well. We back-up ALL data files daily. It takes about 5 min to do and compresses to 600 or so Meg.

A really big file for us is the WOBOM file. It stores all of your work order bill of materials. If you have no need to reference these in the future, you can initialize this file. Just make sure you do not have any unfinished WO's that need these bills for backflushing.

John

EVO-ERP, ISTS 3.27.08 , 2000I 10 user

IP Logged

RAGINE Full Member I love YaBB 1G - SP1! Posts: 150 Gender:	Re: ROUTINE MAINT Reply #2 - 11/03/06 at 07:30:45 JNAPIER, how do you do data compression?
Back to top	Ragine Hendrickson Manufacturing Systems Inc/TRU-CATCH TRAPS ISTECH 2004.1 10/31/06 UPDATE IP Logged

wildco Full Member I love YaBB 1G - SP1! Posts: 174	Re: ROUTINE MAINT Reply #3 - 11/03/06 at 08:34:06 I suggest a DVD-writer. They, and the discs, are reasonable and the write amount is 4.7GB.
Back to top	Aaron 2004.1 with ISTECH 1/12/06 IP Logged

JNAPIER Active Member Evil-Evo Bad Dog! Posts: 533 Gender:	Re: ROUTINE MAINT Reply #4 - 11/03/06 at 08:48:21 Quote from RAGINE on 11/03/06 at 07:30:45: JNAPIER, how do you do data compression? I use Bitzipper http://www.bitzipper.com/ You can use winzip or any other of many. It is nice because you can preset a backup with all the file types, names ect. One click on your desktop icon and away you go. John
Back to top	EVO-ERP, ISTS 3.27.08 , 2000I 10 user IP Logged

RAGINE Full Member I love YaBB 1G - SP1! Posts: 150 Gender:	Re: ROUTINE MAINT Reply #5 - 11/03/06 at 11:13:03 thanks guys!!! So...what if any rountine maint do you do with DBA?
Back to top	Ragine Hendrickson Manufacturing Systems Inc/TRU-CATCH TRAPS ISTECH 2004.1 10/31/06 UPDATE IP Logged

RPCAdmin

Active Member

Please save me from
the Users!!!!!!!

Posts: 521
Gender: male

Re: ROUTINE MAINT
Reply #6 - 11/07/06 at 07:40:50

You can't beat the price of a 250+ Gb usb drive for backups!! We use 3 for redundancy. The main drive does a daily backup of the entire dbamfg directory (Mon thru Friday) and we do end of week backups for the entire server each month. It all fits easily. The second drive is a redundant backup that daily xcopies the primary and the third is another redundant backup that is xcopied weekly and kept offsite.

Mike Nessen
Sr. Engineer/IT Manager/Anything else I need to be
EVO-Erp Build (always the latest) Client/Server
Pervasive 2000i on NT4 Server 15 users

IP Logged

N_Clyde_Jenkins Browser Posts: 14	Re: ROUTINE MAINT Reply #7 - 11/09/06 at 07:38:46 We do daily incremental backups and weekly complete backups. These are done to tape. The server has a Tandberg Data tape drive and we use Veritas Backup Exec to manage the backups. At the end of every month I run SM-J-C Reconcile Inventory (preceded by UT-K-I fix binary zeros). Then I print out the inventory value for our controller.
Back to top	Clyde Jenkins Pioneer Manufacturing EVO-erp 2006.1 05/01/07 IP Logged

RAGINE Full Member I love YaBB 1G - SP1! Posts: 150 Gender:	Re: ROUTINE MAINT Reply #8 - 11/09/06 at 15:42:28 Thanks Clyde, Do you purge any old WO'S, SO's or PO's?
Back to top	Ragine Hendrickson Manufacturing Systems Inc/TRU-CATCH TRAPS ISTECH 2004.1 10/31/06 UPDATE IP Logged

N_Clyde_Jenkins Browser Posts: 14	Re: ROUTINE MAINT Reply #9 - 11/13/06 at 09:16:49 No, we don't purge old stuff. But we should and we will soon. Converting to EVO has been higher on the priority list.
Back to top	Clyde Jenkins Pioneer Manufacturing EVO-erp 2006.1 05/01/07 IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › System Manager

‹ Previous topic | Next topic ›