many thanks again
regards
Jürgen Peter
(CAM Berlin)
--- In [EMAIL PROTECTED], "Torgeir Toms"
<[EMAIL PROTECTED]> wrote:
> No
> Not realy. Perhaps MSTechnet can help you
> Med vennlig hilsen
> Torgeir Toms
> Systemkonsulent Teknisk IT
> _
>
> ==================================
> Good Judgment Comes From Experience. Experiences Comes From Bad
Judgment.
> =====================================
>
> -----Opprinnelig melding-----
> Fra: juepeterberlin [mailto:[EMAIL PROTECTED]
> Sendt: 12. januar 2004 22:44
> Til: [EMAIL PROTECTED]
> Emne: Re: SV: [development-axapta] SQL Server 2000: since some
weeks DB-size grows exponentially
>
>
> Thanks very much Torgeir,
>
> we will try that.
>
> Do you know more about the background of this error?
>
> regards
> Jürgen Peter
> (CAM Berlin GmbH)
>
>
> --- In [EMAIL PROTECTED], "Torgeir Toms"
> <[EMAIL PROTECTED]> wrote:
> > i have experienced that - its an error in SQL Server. I applyed
> SP3a. It fixed it
> >
> >
> > Med vennlig hilsen
> > Torgeir Toms
> > Systemkonsulent Teknisk IT
> > ==================================
> > Good Judgment Comes From Experience. Experiences Comes From Bad
> Judgment.
> > =====================================
> >
> > -----Opprinnelig melding-----
> > Fra: Preston A. Larimer [mailto:[EMAIL PROTECTED]
> > Sendt: 12. januar 2004 16:05
> > Til: [EMAIL PROTECTED]
> > Emne: RE: [development-axapta] SQL Server 2000: since some weeks
> DB-size grows exponentially
> >
> >
> > Looks like you have 3 gigs of unused space, more than likely
> during the upgrade your database grew in size due to the
transaction
> logs and it hasn't shrunk back yet. If your maintenance jobs and
> backups are set correctly to shrink the database you should see
the
> size deflate on the next scheduled maintenance run or you could
> always try to shrink the files manually from the enterprise
manager,
> back up first though.
> >
> > -Preston
> >
> > -----Original Message-----
> > From: juepeterberlin [mailto:[EMAIL PROTECTED]
> > Sent: Monday, January 12, 2004 9:51 AM
> > To: [EMAIL PROTECTED]
> > Subject: [development-axapta] SQL Server 2000: since some weeks
DB-
> size grows exponentially
> >
> > Hi all,
> >
> > since some weeks our DB-size went from 2GB to 5.5 GB although
the
> > user data input was more or less the same.
> >
> > sp_spaceused on the DB results in
> >
> > database_size 5620.00 MB
> > unallocated space 50.03 MB
> > reserved 5375968 KB
> > data 1516608 KB
> > index_size 818368 KB
> > unused 3040992 KB
> >
> > We use Axapta 3.0 SP2 with SQL Server 2000. There is a
> possibility,
> > that this growth began with going from SP1 to SP2.
> >
> > Does someone know anything how such unusual database growth and
> > such an high "unused" factor could happen?
> >
> >
> > regards
> > Jürgen Peter
> > (CAM Berlin GmbH)
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> > · To visit your group on the web, go to:
> > http://groups.yahoo.com/group/development-axapta/
> >
> > · To unsubscribe from this group, send an email to:
> > [EMAIL PROTECTED]
> >
> > · Your use of Yahoo! Groups is subject to the Yahoo!
Terms
> of Service.
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> > To visit your group on the web, go to:
> > http://groups.yahoo.com/group/development-axapta/
> >
> > To unsubscribe from this group, send an email to:
> > [EMAIL PROTECTED]
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/development-axapta/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
