SQL & Backupexec 2012

[Bas00ma]

Dear all,

I can not be able to take backup for SQL server, backup exec throw this error ' The Backup Exec SQL Agent was not used to create the last full backup of this database. You must use the SQL Agent to run a full backup before you run a differential backup or transaction log backup', SQL configured is configured with full inbuilt backup mode.

Any help will be appreciated .

Thanks in advance,

Basem

[pkh]

You have to run a full backup of the SQL databases, before you can run log or incremental SQL backups.

If you are running VM backups, make sure that you do not have a VM backup between the full SQL database backup and the log or incremental backups.

SQL Log Backup job fails if run after an AVVI or Hyper-V backup of the SQL Virtual machine

Differential/Log backup of SQL database fails with the error "The Backup Exec SQL Agent was not used...

[Bas00ma]

Yes, i did full backup first sucessfully for Sql but when i run incremantal backup throw this error .

[VJware]

Check if the LSN was reset or not... From the SQL management studio, right-click on the database, choose standard reports - backup & restore events...

Also, if running any native SQL backups, pls ensure they don't clash with the Backup Exec's jobs.

[rendersr]

Hi,

Check wat the recovery model is on the database (Simple or Full).

Make sure you implement a full backup for the databases before running incremental or differential backups. Can you output us the configuration parameters for the differential job?

How much time is there between taking a full and a differential?

[Bas00ma]

Thanks for your reply, the database recovery model is full.

I run full and Incremental every day , full at the end of business day 16:00 and the incremental at 11:30 Morning .

[pkh]

Make sure you are not running any VM backups or other SQL backup tasks between your full and incremental jobs.