I work with MSDE, now the dimensions are of 2 GB...I have deleted many pages, is possible to compress the database?
Thanks in advanced
What is likely taking up so much space is the transaction log. Each time you perform data updates MSDE (SQL Server, actually) keeps a record of this in a transaction log. Performing a BACKUP operation will automatically clear out the transaction log (because for MSDE the "truncate log on checkpoint" opton is automatically set to ON).Have you performed a BACKUP of your MSDE database?
Alternately, you should be able to perform aDBCC SHRINKDATABASE.
No comments:
Post a Comment