Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

SQL Backup

Updated: 21 May 2010 | 3 comments
dbaish's picture
0 0 Votes
Login to vote

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?

Comments

Ken Putnam's picture
26
Feb
2008
0 Votes 0
Login to vote

1)  If you use SQL to do the backups, and then backup those BKF files, you have to restore the BKF file to disk before you can restore SQL  If you use the SQL Agent, you can restore directly from tape  
 
 

If this response answers your concern, please mark it as a "solution"

Hywel Mallett's picture
27
Feb
2008
0 Votes 0
Login to vote

Also, if you dump the SQL data to disk, then you need more disk space - perhaps not an issue if your DB is 1GB, but more so if it's 1TB!
The SQL Agent can also do things like automate the restore of the master database in the event of a disaster recovery.
David Bond's picture
12
Mar
2008
0 Votes 0
Login to vote

You forget the advantage that using sql server backup and not the agent has, it truncates the log file on a full backup, unlike symantecs full backup which you have to run a second backup on the log files to get rid of them. This is something i found out recently, and you have on you site, but what I have been wondering is, since you run a full backup, the log file backup is basically a waste of space, but because you run it right after the backup and its not the server truncating it based on the full backup, there will probably be changes in database bewteen the time you run the backup of the databases and the time you backup the log files, so you will have to keep them, unlike if the **bleep** agent truncated them in the first place.
I'm complaining about keeping them because of the sizes of the log files i have, recently installed sql server (2 weeks) has over 300GB in transaction logs, and i have multiple sql servers with similar sized log files.