Can anyone tell me what the difference is between using the backup from within SQL to create the backup file and using the SQL agent that Symantec provides. Currently, we create a backup from within SQL and then backup the .bak file to tape. What are the advantages and disadvantages of using either way to backup the data?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Agent
- Thread starter dbaish
- Start date
LawnBoy
MIS
- Mar 12, 2003
- 2,881
Agents introduce another link in the chain that can misbehave, besides costing money. What you are currently doing is simpler and more reliable.
"We must fall back upon the old axiom that when all other contingencies fail, whatever remains, however improbable, must be the truth." - Sherlock Holmes
"We must fall back upon the old axiom that when all other contingencies fail, whatever remains, however improbable, must be the truth." - Sherlock Holmes
- Status