While monitoring the SharePoint health
analyzer, I came across this error - Database has large
amounts of unused space
Following databases have large amounts of space allocated on the
disk but not in use. This may be due to recent deletion of data form the
database, or because the database has been pre-grown to a larger size. This database
will take up a larger amount of space on the file system unless it is shrunk
down to a smaller size.
The database can be shrunk in size using the DBCC ShrinkDatabase
command or the Shrink Database wizard in SQL Server Management Studio.
There are some errors on which you really need to take an action
but this one you can safely ignore! – Yes, you heard it correct. This is not a
critical error and there is no harm in ignoring this error.
If
you really want to take an action then you can simply shrink the database. In
the above error, you will see the name of the database for which its failing so
take the action and you are done.
Resolution:
Two ways – Either by SQL way or Central Administration (CA) way
to remove this error from the Health Analyzer!
SQL way:
1. Login to the SQL management
studio
2. Right click on the
failing database
3. Shrink it.
CA way:
1) Open the Central
Administration
2) Click on the health
analyzer list
3) Click on the rule
which is showing this error
4) Click Repair
automatically option which is on the top ribbon -> Once you click on it then
wait for few mins i.e. give some time to execute that job properly
5) Now there is a time
“Reanalyze Now”
If
you have any queries / questions regarding the above mentioned information then
please let me know. I would be more than happy to help you as well as resolves
your issues, Thank you.
Note:
If you find a different solution, please report it as a comment to
this post. Be sure to double-verify it: undo your solution and verify that the
problem comes back, then redo it and verify that the problem goes away.
Product Applies To:
a) SharePoint Server
2010
b) SharePoint
Foundation 2010
Reference:
