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?
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
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
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)
I am deleting the journal older than 2 months in a daily basis, nothing to lose
Have something to add? Share your thoughts — no account required.
Ask the community — no account required