08-11-2014 07:40 AM
Hello!
We have changed MS SQL edition from Enterprise to Express on two of our servers. After that we got problem with backing up their SQL databases:
Job which generate this error was created specially for backing up MS SQL databases. Selection list:
view by resource:
As you can see "Microsoft SQL Server" is not selected for backing up for that two servers.
Job properties: Backup method for MS SQL "Full - Back up Entire database or filegroup", AOFO is enabled
The solution for this problem
suggests several things to try. One of them which is seems appropriate is disable AOFO, which was enabled before we changed MS SQL edition and it didnt cause errors. When i disable it i get new error:
What could be done here?
Solved! Go to Solution.
08-11-2014 07:47 AM
08-11-2014 07:47 AM
08-11-2014 07:49 AM
I'd start by doing some test jobs of only 1 resource at a time with or with AOFO enabled to see if they work on their own (even down to separating the SQL backup from the Shadow Copy backup)
08-12-2014 05:58 AM
I've simply recreated the selection list for the policy and it works.