Easy question re: BEWS behavior with SQL databases

[JoeyJoeJoe]

BEWS 11d.

I have a couple of SQL databases that are getting backed up nightly. Full backup. No consistency checks before or after. No checksum and no "create on-disk copes of SQL backups"

It's a pretty basic full backup each night and I was wondering. Is the database stopped or locked during the backup process? We have some services communicating with our SQL databases that go "belly up" every night and we are trying to find out if it is related to the nightly backups.

Thanks,
JJJ

[Ben_L_]

Is the database stopped or locked during the backup process?

No, Backup Exec sends a command to SQLVDI to backup the databases.  The databases should still be online and accessable.

Now if you are using AOFO in the backup job, this may be causing an issue for you as this does point in time backups of the database.  I would check to make sure that this is turned off for any SQL backup.

[JoeyJoeJoe]

Thanks Ben,

Just to make this clear, the Advanced settings in my nightly SQL backup includes "Open file backup when Advanced Open File Option is not used" and I have "With a lock" selected.

So that means BUExec is locking my databases, then backing them up. Right?

Thanks,
JJJ

[Ben_L_]

So that means BUExec is locking my databases, then backing them up. Right?

No, that setting is for file level data only not SQL agent backups.