Vault General Discussion

Reply
Distinguished Contributor
spascual
Posts: 292
Registered: ‎11-17-2009
Message 1 of 2 (137 Views)
Accepted Solution

SQL maintenance plan options changes in 2012 version

137 Views, 1 Replies
05-11-2011 02:00 AM

Hi Sirs,

 

I can see that in ADMS advanced configuration guide, options for SQL maintenance plan have changed. Now we do not check shrink database option.

 

Is important to reconfigure the SQL maintenance plan for previos versions??? 2011, 2010,...

 

thanks

 

regards

Employee
paul.gunn
Posts: 442
Registered: ‎06-07-2010
Message 2 of 2 (128 Views)

Re: SQL maintenance plan options changes in 2012 version

05-11-2011 06:00 AM in reply to: spascual

 

Hi,

 

That recommendation would be good for previous releases as well. Guidance from Microsoft indicates that shrinking the database has adverse effects like fragmenting the table indexes. And it doesn't really provide much benefit since the database will eventually autogrow anyways. In general I would advise not having this option enabled.

 

Paul

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
New button for Platinum & Gold Subscription customers
Gold & Platinum Subscription customers can alert Autodesk if they require assistance with their forum post

Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community