AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



EXPONENTIAL SQL Growth? Expand / Collapse
Author
Message
Posted 5/13/2008 5:07:07 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 5/28/2008 10:15:00 PM
Posts: 97, Visits: 124
For three years I used Ayanova nad when I imported into version 4 using SQL express the database was 110Mb in size.  I ran a SQL backup using the Studio management Express software and the size was about 140Mb.  5 days later I just ran the backup again and it is now at 470Mb in size?  Is there something with the new version that cause the database to grow that much?

I have entered maybe 50 workorders in these past few days, the only difference being that I am using the templates now?

Post #4011
Posted 5/13/2008 5:26:46 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 7:45:59 AM
Posts: 1,866, Visits: 4,324
Hi Steve

Check out the topic http://forum.ayanova.com/Topic1912-111-1.aspx?Highlight=sql+grow

You want to do a regular "simple" backup using the SQL backup manager to maintain proper growth, as well as perform SQL maintenance on your database such as that identified in http://forum.ayanova.com/Topic1923-111-1.aspx?Highlight=sql+maintenance

Your database and log file could be fragmented and by backup and maintenance, you bring it back to normal. Do check that out.

Also, check your SQL help file about SQL databases and their maintenance, as well as online.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #4012
Posted 5/14/2008 7:46:37 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 5/28/2008 10:15:00 PM
Posts: 97, Visits: 124
Thank you for the input on this but chalk it up to "User" stupidity.  I had set the SQL backup and my office admin runs it daily, one of the boxes had been changed and I did not think of checking the settings again - It was set to append the backup and not overwrite  ...
Post #4013
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 7:50am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.094. 10 queries. Compression Disabled.