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

2005-04-26 Thread David Casas
:58 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Antwort: Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB Hi, I tried this, but the real problem is the .mdf file. this one increases from 10 Gb to 13 Gb. the log file has 5 gb, but i have delete it. so

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

2005-04-25 Thread Jesper Kehlet
@yahoogroups.comSubject: Antwort: Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB Hi, I tried this, but the real problem is the .mdf file. this one increases from 10 Gb to 13 Gb. the log file has 5 gb, but i have delete it. so the other problem ist, that on normal use the

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

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

2005-04-25 Thread sguettler
Hi, I tried this, but the real problem is the .mdf file. this one increases from 10 Gb to 13 Gb. the log file has 5 gb, but i have delete it. so the other problem ist, that on normal use the db.file  increases 3-4 Gb per  year. so what strategy is the best way to shrink the .mdf file? than