Delete old sales jounals

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?