cancel
Showing results for 
Search instead for 
Did you mean: 

Separate backup job for Server and SQL of BE server ?

William_Lawance
Level 6

Hi,

Just migrated BE server from 2010 to 2014.

Do I need to separate backup job for BE server ?

  • FULL server backup (1 job) + SQL (1 job) in different job
  • FULL server backup + SQL in same job (1 job)

Which should be used ?

 

Thanks

8 REPLIES 8

VJware
Level 6
Employee Accredited Certified

You can keep them in the same job.

However, I would recommend two separate jobs -

Full server backup with AOFO on.

SQL backup with AOFO off.

William_Lawance
Level 6

SQL is backing up, then do I need to backup SQL DB is file base ?

thanks

VJware
Level 6
Employee Accredited Certified

Just re-read your query.

For a backup of BE server itself, you do not need to backup SQL. BE automatically backs up the SQL DB as part of a daily maintenance. You need to backup only the regular file data such as C:\, System State etc.

CraigV
Moderator
Moderator
Partner    VIP    Accredited

...BE will backup bedb.bak to be precise. Unless you have the SQL agent installed, it won't touch SQL and will in fact exclude the *.ldf and *.mdf files.

William_Lawance
Level 6

Like this ? Select MS SQL Server Instance is ok ?

How about for other SQL server ?

If SQL DB put in R:\, do I need to backup DB files in R:\ ?

Or like BE server to backup MS SQL Server only ?

Thanks !

CraigV
Moderator
Moderator
Partner    VIP    Accredited

...for installed files you can select R:\, and Backup Exec will exclude the *.mdf and *.ldf files through Active File Exclusion. The selection in your post above is fine.

Thanks!

Colin_Weaver
Moderator
Moderator
Employee Accredited Certified

If you are only looking at the BEDB instance and not another application running in SQL then you could schedule the BEDB maintenance for 10 minutes before the backup job starts and then just backup the BEDB.bak file from the data folder and not actually do a SQL backup of the BEDB (which would then mean you are not using the SQL Agent and therefore do not need an Application and Databases license).

 

Note: A standard Backup Exec Server license does not include the applications and databases license so you would need to add such a license to backup the BEDB if you continue to back it up via the SQL selections (you might be in trial/evaluauon mode for 60 days)

William_Lawance
Level 6

This means both SQL and SQL DB partition (R:\) can be selected to backup