cancel
Showing results for 
Search instead for 
Did you mean: 

EV Database log backups in 'Simple' mode

KeirL
Level 6
Partner

Hi

Am I able to set the EV logs into Simple mode as our backup solution doesn't truncate the logs well. If I go into simple mode and use SQl backups is recovery any more difficult if we get a corruption.

 

many thanks

Keir

1 ACCEPTED SOLUTION

Accepted Solutions

JesusWept3
Level 6
Partner Accredited Certified
To be honest, point in time restores and transaction log replays are pretty tricky and can actually lead to far more inconsistency than regular restores A fair number of customer use simple logging instead of full and this also increases performance of EV as well in many cases
https://www.linkedin.com/in/alex-allen-turl-07370146

View solution in original post

6 REPLIES 6

JesusWept3
Level 6
Partner Accredited Certified
To be honest, point in time restores and transaction log replays are pretty tricky and can actually lead to far more inconsistency than regular restores A fair number of customer use simple logging instead of full and this also increases performance of EV as well in many cases
https://www.linkedin.com/in/alex-allen-turl-07370146

KeirL
Level 6
Partner

So nothing more needs to be done in EV - it's just a case of changing the database setup from Full to Simple?

Thanks

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

Correct, this is a SQL change and EV the application doesn't care either way.

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified

Use SQL to make backups of the logfiles, and truncate them.

write the backup files to a folder somewhere.

Have the backup software backup that folder.

configure sql to keep the backupfiles for an x number of days/weeks, whatever you need.

Regards. Gertjan

KeirL
Level 6
Partner

So how does EV determine if the database backups have been successful? I know that with the Vault Stores it can be set to look at the archive bit or for a trigger file. Does it only look at the Archive bit with the SQL databases and\or some process associated with the log truncation activity?

Thanks

K

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

EV checks the Last Database Backup date in SQL to determine if the db has been backed up or not.  If you look on the properties of the SQL db  you will see a last backed up date, that is what it is looking at.