03-22-2012 12:11 AM
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
Solved! Go to Solution.
03-22-2012 04:38 AM
03-22-2012 04:38 AM
03-22-2012 04:43 AM
So nothing more needs to be done in EV - it's just a case of changing the database setup from Full to Simple?
Thanks
03-22-2012 05:46 AM
Correct, this is a SQL change and EV the application doesn't care either way.
03-22-2012 07:38 AM
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.
04-02-2012 04:53 AM
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
04-02-2012 05:09 AM
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.