i got a huge dabatase where its mdf file is about 22G of size!! I need to reduce this size. I was thinking of shrinking the database, it seems that the admin who left set a schedule to shrink this DB ( look at the attached jpg) but it seems that it was failing. i attached the error as well.
my question is, is shrinking my only option here?
what are the recommended settings for shrinking a DB?? i need a spicific answer plz. . like, what shall i set in "Maximum free space in files after shrinking: "default is 0%"
and shall i keep "Move pages to beginning of file before shrinking "unchecked""
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.