MOSS2010 DB skipped during SQL backup

To backup SQL, you require SQL license present.

Today only installed BER3 which is 60 day evaulation trial. And i believe evaluation copy allows SQL & other agents to be used.

I mentioned earlier  that few DBs within selection are getting backed up but rest are skipped with notification "use sharepoint to backup this database" however db which are backed up are of sharepoint farm only.

It confuses alot to me, how come few db are backed up and rest are skipped just being dependent of agent.

Hi,

I believe the the OP might already have the SQL agent installed, and wants to know if they can use that to back up the MOSS DB...correct me if I am wrong?

Otherwise have you tried selecting the SQL DB from the SharePoint farm itself...?

Thanks!

Thanx craig for understanding my issue

Yes ur correct i'm trying to backup moss db using sql agent, somehow few dbs are getting backed up but rest dbs are getting skipped.

i found selction funnny where few db were greyed out and only those were skipped.

i didn't face this issue while backing up moss  2k7 in same manner.

any idea if this works

moreover does aofo needs to be enabled while configuring sql dbs (sounds funny with intellegent agent)

cheers

vaibhav

Don't use AOFO when backing up those DBs. Let BE itself decide what to use.

Have you either unselected the DBs and then reselected them, or uninstalled/reinstalled the SQL agent? Are all these DBs on the same box?

Ya all dbs are in same box

have reselected dbs and also tried after reinstalling agent. but does not works.

have tried with sharepoint agent it worked... but i can't go with sharepoint agent as we are not gonna buy license now. so sql would be helpful to me.

cheers

vaibhav

Active File Exclusion prevents duplicate resource protection.  If an agent is installed for a specific resource, the ability to select the resource from any other selection list trees, in this case, SQL Agent tree and flat-file system tree is automatically disabled.

This seems something different.

From SQL point of view, Database will remain as it is irrespective of data it holds and the application using the same.

Backup Exec should allow this DB to be backed up. Don't know how same agent filters this category and works.

@Aremboldt,  the flat files are skipped whether the Agent is installed or not, unless you use the tweak to turn AFE off