Deleted Journals from SQL

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 please. Thanks

Reply to
Akbar Mian
Loading thread data ...

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.