Re: Antwort: Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB

2005-04-26 Thread David Casas
.    Regards.   David     - Original Message - From: Jesper Kehlet To: Axapta-Knowledge-Village@yahoogroups.com ; Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, April 26, 2005 12:53 AM Subject: RE: Antwort: Re: [Axapta-Knowledge-Village] After Upgrade DB increases

RE: Antwort: Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB

2005-04-25 Thread Jesper Kehlet
Just one more note on this:  If your data file grows, cool, that means employees being busy!  I know of companies whose database grows by 1GB per WEEK and more!  3-4GB per year is not unusual!!!   If you log file grows, take a look at your backup schedule, backup software, and maintenance

RE: Antwort: Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB

2005-04-25 Thread Jesper Kehlet
-Village] After Upgrade DB increases over 13 GB It is not a good idea to shrink the data file. The data file growth is dependent on the growth option you set on it. If you set it to say 10% and the initial size is 100G it will grow to 110G when all the 100G of space is all use up. It will then grow

Re: Antwort: Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB

2005-04-25 Thread Varden Morris
It is not a good idea to shrink the data file. The data file growth is dependent on the growth option you set on it. If you set it to say 10% and the initial size is 100G it will grow to 110G when all the 100G of space is all use up. It will then grow to 121G next and so on.   The fact that it