cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Database Recovery Models

jacob_crawford
Dynatrace Helper
Dynatrace Helper

DB Admins are about to upgrade from from SQL2005 to SQL2008 r2 and pointed out an inconsistency in the defined recovery models between APM databases. They requested we use one model for all to maintain consistency, and my immediate thought is Simple for all 4. Currently:

  • VAS - Full
  • AWDS - Simple
  • CSS - Full
  • EnterprisePortal - Simple

I know Simple recovery is recommended for CAS and AWDS, but I haven't located the recommendation for CSS and EnterprisePortal.

Also, I know this is CV-related but we're also upgrading VantageViewDB12 and ClientVantage which are set to Full recovery... if anyone happens to know the recommendations for these as well that would be helpful, otherwise I can post a separate topic in the Synthetic forums.

Thanks,

Jake

4 REPLIES 4

adrienne_simows
Participant

For EP and CSS we recommend Simple.

 

jacob_crawford
Dynatrace Helper
Dynatrace Helper

Thanks Adrienne!

robert_miller
Inactive

Simple recovery is also recommended for CV and VV

Thanks for the quick responses. Will pass this onto the customer.

 

-Jake