Link to home
Start Free TrialLog in
Avatar of swgit
swgitFlag for United States of America

asked on

Please Help with Steps to Shrink/Compress SQL Databases

Dear Experts

Could you please help me to shrink / compress SQL databases?  Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of swgit

ASKER

Raja - Thank you for your quick response.  My SQL server gets full almost daily.. I am just trying to figure out how to slow down the growth so that I have enough time to clear the logs and such..  I will try the steps from the link you sent, starting out with the log files.  Will keep you posted..  Thanks!
Did you see in Explorer if there is available space in data/log file?
If there is available space then only you can shrink it. Right click on DB -> Task -> Shrink -> Files. And also check if your DB is in simple recovery mode.
>> My SQL server gets full almost daily.. I am just trying to figure out how to slow down the growth

If that is the case, then I would suggest you to check all the Log tables and perform purging of those tables to keep up your table sizes in control to have the database growth in control.
If there aren't any tables to be purged, then you might need to do capacity planning and increase your storage space as shrinking data files on a daily basis is not recommended..
My SQL server gets full almost daily
99.9999% of the databases aren't static so growing is the expected behaviour.
Instead of trying to find a solution to shrink databases you should think in having a better Capacity Management for your databases so they can have enough disk space to grow without causing issues.
You can also enable the native SQL Server compression feature on large tables.
Avatar of swgit

ASKER

@raja - thank you. i did not shrink the database, but did experiment on “better” maintenance plans and recovery modes.. so far so good!
Thanks for updating and implementing the Maintenance plans better..