Delete Old Receipts

My database is getting bigger every day. I think is because RMS store every receipt in a images format and those images takes a lot of disk space. right? I would like to delete old recepits. How can i delete those receipts and what effect would I have if i delete them.

any ideas?

Reply to
Troper
Loading thread data ...

My database is getting bigger every day. I think is because RMS store every receipt in a images format and those images takes a lot of disk space. right? I would like to delete old recepits. How can i delete those receipts and what effect would I have if i delete them.

any ideas? -- Thanks Troper

Reply to
CptSoft

My database is getting bigger every day. I think is because RMS store every receipt in a images format and those images takes a lot of disk space. right? I would like to delete old recepits. How can i delete those receipts and what effect would I have if i delete them.

any ideas? -- Thanks Troper

Reply to
John M.

John, That looks like a really good idea. I'm assuming i could change the -365 to -730 or any number of days I would like to keep. Does anyone know of any reason not to run a command like that regularly? Are there any repercussions to doing it? Craig

Delete JOURNAL where time < getdate()-365 dbcc shrinkdatabase (dbname,10)

Reply to
Craig

I am deleting the journal older than 2 months in a daily basis, nothing to lose

Reply to
Mahmoud Amin

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.