Backup Exec Persistent Errors-SQL Server-Sharepoint
I have symantec backup exec setup with 6 different hard drive, one for everyday of the week and two for friday. Each removable USB harddrive is setup as its own non-removable device, each one with a different B2D folder on it, and they are all placed into the same device pool. Symantec is setup to run with partial overwrite protection, without prompting. Everywhere it is possible, I have allowed for overwriting.
I am backing up domain controllers, exchange server, as well as a sharepoint server, and a SQL database on the same machine. I am having many problems with the SQL/Sharepoint backups. I am consistently getting error messages that the resource (i.e. the Sharepoint server with SQL) does not support the option to enable the restore of individual items. I realize this has to do with granular recovery. I have the granular recovery option checked in the SQL server/sharepoint settings in Symantec, AND I have the option of a FULL backp enabled both in Symantec and in each of the SQL databases, yet I still get this error.
Also, I am getting errors for each of the databases (all that have a FULL backup enabled) that: so and so database is config’ed to maintain transaction logs. Transaction logs are not being performed. This will result in the log growing to fill all available disk space. Regular log backups should be schedules or the database should be changed to “simple” recovery mode.
Now, if I change the SQL databases to simple, then wont this conflict with the granular recovery? (even though it doesn’t seem to be working anyway, this is how I understand it).
Any help would be greatly appreciated