Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

AD and Sql Backup backup through Window agent

Created: 28 Mar 2014 • Updated: 28 Mar 2014 | 4 comments
roh234's picture
This issue has been solved. See solution.


i would like to know if we dont purchase the agent for application and database for my AD server and SQl server,i will purchase only agent for window 

then is there any method i can take the back up of both server and ensure there recovery even if i need to do the backup in off time when no user is working 

on these 2 server 



Operating Systems:

Comments 4 CommentsJump to latest comment

CraigV's picture


You can take a System State backup but won't be able to restore AD items.

You can use SQL to make a backup nightly of your SQL databases, and then point BE to that particular folder and backup the *.bak files. However, to restore SQL databases you'd need to restore the *.bak file and then use SQL to mount it. You won't be able to restore while SQL is live.


Alternative ways to access Backup Exec Technical Support:

roh234's picture


you said i am not able to restore the AD or according to Pkh artical i am not able to restore the indivisual AD objects i need to restore the entire AD.


CraigV's picture

We're both right. You would need to restore the entire System State, and therefore AD as a result of that and lose any changes made.

this is the risk you run when not using agents. They do cost more money, but the functionality behind them justifies this. You can always read below if you want justification:

Alternative ways to access Backup Exec Technical Support:

pkh's picture

For AD, read my article below for various backup options

For SQL Server database, note that AFE will automatically exclude any .mdf and .ldf files from being backed up.  Thus, as previously advised, without a SQL agent, you need to do a 2-step backup/restore.