Vault General Discussion

Vault General Discussion

Reply
Distinguished Contributor
297 Posts
5 Kudos
Registered: ‎11-17-2009
Post 1 of 2
Accepted Solution

SQL maintenance plan options changes in 2012 version

140 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

 

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

Employee
499 Posts
28 Kudos
Registered: ‎06-07-2010
Post 2 of 2

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

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
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.