Community
Vault Forum
Welcome to Autodesk’s Vault Forums. Share your knowledge, ask questions, and explore popular Vault topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL maintenance plan options changes in 2012 version

1 REPLY 1
SOLVED
Reply
Message 1 of 2
spascual
302 Views, 1 Reply

SQL maintenance plan options changes in 2012 version

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

1 REPLY 1
Message 2 of 2
paul.gunn
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

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report