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 Maintenence

3 REPLIES 3
SOLVED
Reply
Message 1 of 4
CAD-One
396 Views, 3 Replies

SQL Maintenence

http://crackingthevault.typepad.com/crackingthevault/2011/09/dont-forget-to-run-a-maintenance-plan.h...
How often do you guys do this?
C1
Inventor Professional 2020
Vault Professional 2020
AutoCAD 2020
3 REPLIES 3
Message 2 of 4
xavier_dumont2
in reply to: CAD-One

Hello,

 

We do this once a week (saturday) by our customers.

 

Best regards.

Message 3 of 4
scottmoyse
in reply to: CAD-One

We run an incremental backup every Mon-Thurs then a full every Friday. The script we use to run the backup also resets the SQL server AUTODESKVAULT instance to purge the massive amount of memory it begins to hog. iisreset is now part of the backup proceedure controlled by the ADMS console, so you don't need that in the script anymore.

The Friday script deletes all the incrementals from the previous days prior to running the full backup.

 

We then have a company 'Global' server backup policy which backs up all the Admin drives etc and the location the vault backups are saved to each day. The 'Global' backup is on a fortnightly cycle.


Scott Moyse
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.


EESignature


Design & Manufacturing Technical Services Manager at Cadpro New Zealand

Co-founder of the Grumpy Sloth full aluminium billet mechanical keyboard project

Message 4 of 4
CAD-One
in reply to: scottmoyse

Scott,

Thanks for sharing these details

C1
Inventor Professional 2020
Vault Professional 2020
AutoCAD 2020

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

Post to forums  

Autodesk Design & Make Report