Backup Exec 2010 and Microsoft SQL
Posted on 2013-11-04
Let me start by saying i do not know alot about databases and what should and shouldnt be backed up, thus brings me to my question. Backup exec backs up the server and the Microsoft SQL but when it completes i have the following exception:
V-79-40960-37914 - Database Prod_Vault is configured to maintain transaction logs. Transaction log backups are not being performed. This will result in the log growing to fill all available disk space. Regular log backups should be scheduled or the database should be changed to the simple recovery mode.
So should i change to simple recovery mode? If so what changes and what does it effect if anything?
Should i setup a backup to backup this log file as well? Will that take the exception away? Does this transaction log need to be backed up?
Windows Server 2003 x64
Backup Exec 2010
Server 2008 x64
Microsoft SQL 2008
I would like to say thanks in advance for any help in this situation.