Link to home
Start Free TrialLog in
Avatar of Minesh Shah
Minesh ShahFlag for India

asked on

sharepoint 2010 database - data file shrink for service application databases.

Hi Friends,

I get an message on Central Admin of SharePoint 2010 farm as a part of health reports:

1.Title - Database has large amounts of unused space
2.Explaination -
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. DSI_Search_Service_PropertyStoreDB on <db instance name>.

3. Remedy -

The database can be shrunk in size using the DBCC ShrinkDatabase command or the Shrink Database wizard in SQL Server Management Studio. For more information about this rule, see "http://go.microsoft.com/fwlink/?LinkID=167144".

4. Failing Services -

SPTimerService (SPTimerV4)
I am pretty much aware about shrinking of content databases.
I want to know how much risky is the shrinking of service app databases or any other sp system database is?

From your ie expert point of view.

This db .mdf is 3 gb & not a problem at all.

started concerning after i saw this -

http://technet.microsoft.com/en-us/library/cc262731(v=office.14).aspx#DBMaintenanceForSPS2010_ShrinkingDataFiles
ASKER CERTIFIED SOLUTION
Avatar of QPR
QPR
Flag of New Zealand 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
SOLUTION
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
SOLUTION
Avatar of Sushanta Sahu
Sushanta Sahu
Flag of Canada 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
SOLUTION
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 Minesh Shah

ASKER

ok