cancel
Showing results for 
Search instead for 
Did you mean: 

BE 2012 & SQL

MaximusK
Level 4

The use of SQL Agent for backups on sql server (.bak), BE reports an error that another application is already backed up and you need to run a full backup again. whether it is possible to combine the creation of something like the backed up copies of BE and SQL Agent (Jobs) ?

 

1 ACCEPTED SOLUTION

Accepted Solutions

pkh
Moderator
Moderator
   VIP    Certified

1) You should use only one product, preferably BE, to backup SQL.  If you use another product or SQL Studio to do a SQL backup, you would disrupt the BE backup sequence and you will get the error message that you got.

2) You should have 2 jobs: One with AOF on to backup files/folders and the other with AOF off to backup SQL database.

View solution in original post

1 REPLY 1

pkh
Moderator
Moderator
   VIP    Certified

1) You should use only one product, preferably BE, to backup SQL.  If you use another product or SQL Studio to do a SQL backup, you would disrupt the BE backup sequence and you will get the error message that you got.

2) You should have 2 jobs: One with AOF on to backup files/folders and the other with AOF off to backup SQL database.