Typically you set up the SQL server maintenance jobs to dump backups into the backup directory and then you use backup software to back up this backup directory. Otherwise you use software specifically designed to back up SQL like Tivoli Storage Manager tdpsql.
All backup software (including SQL Server backup software and backup agents like Tivoli, CommVault, etc) use the <a href="http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-the-backup-database-command/">BACKUP DATABASE</a> command to backup the database to either disk or tape. You can manually run the command as needed, or schedule it via a SQL Agent job, or use another scheduler. You can also use the maintenance plans to control the database backup.
Last Wiki Answer Submitted: February 16, 2009 10:13 pm by Technochic56,975 pts.
All Answer Wiki Contributors: Technochic56,975 pts.