I have years of old journals and my database is getting too big. How do I get rid of them.
Delete old sales jounals
Jun 20, 2008
6 Replies
Run this SQL statement in Administrator
DELETE Journal WHERE time < getdate()-365
The above statement will delete all journals over 12 months old (alter the number of days as required)
and then run this SQL statement
dbcc shrinkdatabase (DatabaseName)
Before you delete, why do you think your database is too big? We, after doing some 75 stores, have NEVER had that problem.
Check you log files. I find these take up huge amounts of space.
My Back Up file that we update every night is 1.2 gb and when we make a once a week back up to take offsite it takes about five hours. Also since we upgraded to the new rms ver. 2 everything is running much slower.
Where would I find them?
Everything seemed to work as you suggested. My back up file did get smaller but all the sales registers are still visable in the journal viewer. Are registers different from journals?
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required