For backing up SQL Server I take a daily backup, which is stored offline, but also during the day I take 15 minute incremental TLOG backups.
I am currently using BackupAssist to take these backups, however backup assist only allows 1 backup to be run at one time, so when my daily server backup is taken, the SQL backups are queued for 2 hours.
Do people generally just use SQL server agent for backing up? Is it possible to get SQL to email backup reports?
Advise on best practice would be great.
I am currently using BackupAssist to take these backups, however backup assist only allows 1 backup to be run at one time, so when my daily server backup is taken, the SQL backups are queued for 2 hours.
Do people generally just use SQL server agent for backing up? Is it possible to get SQL to email backup reports?
Advise on best practice would be great.