swgit
asked on
Please Help with Steps to Shrink/Compress SQL Databases
Dear Experts
Could you please help me to shrink / compress SQL databases? Thanks.
Could you please help me to shrink / compress SQL databases? Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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..
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 daily99.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.
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..
ASKER