Backup Job failing (SQL)
I am having issue with a backup job, which keeps on failing. First of all, I am using BE2012 with SP2 installed. BE2012 is running on a Windows 2003 Server with SP3. The server whos job is failing is a Virtual Machine on a VmWare 4.1 Environment.
Server itself is a SQL server. I have setup a Full backup on fridays, and then incremental\differential from Mon-Thu
I initially had Incremental setup for Mon-Thu, but it kept failing saying that the log database is not supported and set the recovery mode to Full etc. I checked on my SQL and figured that the recovery mode was set to Simple. I read throuh alot of technotes and forums, and figured that to keep on taking backups in Simple mode, i had to use Differential backups.
So i did a new Full backup (which completed successfully) and then set it up with Differential from Mon-Thu. Now Monday Diffrential failed again saying that last full backup of database was not made by this application. I will post both the Incremental error and Differential error i received.
Solution it provides is something which does not work for me. It says that i need to change the SQL job settings to something else. I am confused.
Another thing i figured was that it recommends we setup 2 different incremential jobs, one for log and one for Differential. Why is that?