Shrink data base SQL Server 2008 -
hi have made maintenance package in have used shrink database task specific database, ran successfully, found slight increase in previous db size. initial size(129 gb) after running package(130gb). i expecting after shrinkning should shrink? might happen? sure package scheduled run , check history found run successfully. any help/ please advise special care required, in advance. do not shrink database during maintenance. there no other more damaging action can do. read more @ auto-shrink – turn off . if database has grown size, grow if shrink it. shrinking database tremendously damaging index fragmentation , slow down reporting , analytic workloads. once shrink, when database grow during normal operations auto-growth events interrupt , freeze database during growth. there 1 thing shrink database had got out of control due rogue action increased it. have shrink in maintenance task means on scheduled interval, , very bad .