October 4, 2015 at 11:53 am
We are currently running sharepoint with SQL 2012 database. The consultant who configured Sharepoint for us is advising/insisting that we setup a daily maintenance job to shrink the data and log files. He is insisting that the lack of maintenance job to shrink the files daily is the reason we are running out of disk space. Is this a good advice?
Thanks,
MC
October 4, 2015 at 4:48 pm
That's the worse advice I've ever heard, what you need to do is provide more space to a clearly under provisioned system. Presumably when the system was first designed somebody took account of how much the Sharepoint system was going to hold?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2015 at 5:11 pm
Absolutely terrible advice. If you're running out of space it means you don't have enough disk space for the database.
Shrinking a database should NEVER be a regularly scheduled operation. It's something done after an unusual operation has increased the size of the DB far above what it needs to be for regular operation, or after a large data archive/delete has been done. In either case, the shrink is a once-off operation.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2015 at 6:54 am
Agree. Automating a shrink is never good advice. Several apps have been installed here where they schedule a shink... I disable the job then delete it later.
October 6, 2015 at 8:44 am
Reminds of the time when I was told to enable autoshrink. Not good.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply