1. Home
  2. Point-Of-Sale Software
  3. Delete old Journals from Sql

Delete old Journals from Sql

Hi! Can some one please help me? I use RMS 2.0 with 2005 Express server, the data reached upto 169 MB 100% used I deleted Journals befor Dec 31,07 as DELETE Journal where time < getdate()-377, Ran the query on my database, which worked fine. However, it made the database size nearly 36 MB more available space. Then I ran the ShrinkDatabase script dbcc shrinkdatabase (MyDatabaseName) but it went back to roughly the same size again Size: 145Mb Space Available: 6.43 Mb Usage: 89% I run again DELETE Journal & then ShrinkDatabase script but available space went back to less space Size: 145Mb Space Available: 3.54Mb Usage: 98% Just for test when I creat a new Database, it have more space than old one. Should I need to ran the reindexed script ? Or any other help please. Thanks

Reply to
Akbar Mian
Loading thread data ...

Reply to
Craig

Thanks Craig for your help, but tell me that Should I need to ran the reindexed script after delete Journals? Thanks

"Craig" wrote:

Reply to
Akbar Mian

It never hurts to reindex. Craig

Reply to
Craig

Reply to
Akbar Mian

after you delete the journal

run dbcc shrinkdatabase (DatabaseName) then reindex (Store operations -->database-->reindex) I run this combination of shrink and reindex 3-4 times One time a ran some tests and each time i did it the database got a bit smaller , it stopped making a significant differance after about 5-6 run I don't know why it gets smaller on each run but it does and does not seem to affect the database

As always test all of this on your test system and backup before you run on live system

H> Hi! Can some one please help me?

Reply to
Robert

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.