SO Database 4G limit

We reduce the database size very often for customers. Contact me via e-mail.

Marc Cott> Hello everyone I need help! I am using Store Operation and my database is at > 4.1G

Hi Jameer,

I don't know about the eventlog file but in our database we removing records from fallowing tables on monthly bases:

- Journals no need to store journals more that 3 months old (unless you really need it), all transaction info will still stay in database but digital "picture" of the receipt will be deleted.

- TimeCard every time when cashier log in \ log out to register that is recorded in this table.

- RecordDeletedLog every deleted line in RMS is recorded in this table.

DELETE Journal WHERE Time The limitations is 4G. Everynight I am shrinking the database to keep things

We have an Archive Utility that may be useful for you.

hi Jameer, If the databse is grow I would recommend you to stop the using MSDE edition of SQL server instead use the sql server personal or standard edition. Regarding the log file, I am writing below some commands apply this but make the backup first.

go to query pane and run this: select * from sysfiles (then get the files name)

ALTER DATABASE SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (QSDB_Log, 1); GO -- Reset the database recovery model. ALTER DATABASE SET RECOVERY FULL; GO

"Jameer" wrote:

We faced this problem ourselves over a year ago. What we did was make a backup, we shrank the database by eliminating transaction data. I recall all the inventory, products, prices were left intact. We simply kept the old version of the database for archive purposes.

The only other factor we needed to keep an eye on was the gift cards. We resold these gift cards/certificates in into the new database using a dummy account.

With this > hi Jameer,