I'm a fairly new SQL Server DBA but come from a software engineering background. I've been reading on several blogs that shrinking a database on a regular basis is bad and I understand why. The issue I'm having is that a database maintenance plan that was in place before I started working is failing. There is only 1 step in the plan and it includes a check database integrity task, rebuild index task, update statistics task and lastly a shrink database task. This plan is scheduled to run every Wednesday and Sunday at 10pm.
I need some suggestions on how to further identify where the issue is and wondered if the shrink database task may be causing the problems.
Thank you for your patience in answering this question from a newbie.