09-20-2015 07:32 PM
Hi,
Just migrated BE server from 2010 to 2014.
Do I need to separate backup job for BE server ?
Which should be used ?
Thanks
09-20-2015 08:59 PM
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.
09-20-2015 10:14 PM
SQL is backing up, then do I need to backup SQL DB is file base ?
thanks
09-20-2015 10:21 PM
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.
09-20-2015 11:28 PM
...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.
09-21-2015 12:39 AM
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 !
09-21-2015 12:57 AM
...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!
09-21-2015 03:19 AM
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)
09-21-2015 08:54 PM
This means both SQL and SQL DB partition (R:\) can be selected to backup