I'd like to share with you this simple snippet (answering my own question) and I'm also curious how do you control your SQL server backups.
Sql-server – SQL server 2005 backup statistic
backupsql-server-2005sql-server-2008
Related Question
- Sql-server – Copy a SQL Server 2000 database to another box without interrupting the backup chain
- SQL Server – Restoring 2008 R2 Backup on 2005
- SQL Server 2005 – Backup All Databases into One .bak File
- SQL Server 2005 – SQL Native Backup MIRROR TO Performance
- SQL Server – How to Backup to a Network Share Through a Separate NIC
- Sql-server – SQL Server backup versus third party snapshot based backup using VSS
- SQL Server Backup – Restore to Start or Finish Time?
Best Answer
One of the slickest ways I've seen to control backups is Ola Hallengren's free maintenance script solution:
http://ola.hallengren.com/
It's installed as a series of stored procs in Master that do all kinds of nifty utility tasks. It'll automatically handle newly added databases, leverages third party backup compression tools, and does index rebuilds/defrags too.