automssqlbackup
Automatically backup MS SQL Server databases
Function
automssqlbackup is a Powershell script using MS SQL Server's SMO library to create full and incremental backups of MS SQL Server databases.
The script is a translation of automysqlbackup.sh which creates backups of MySQL databases under Linux.
Features
- Rotation of daily and weekly backups
- Optionally zipping backups using SharpZipLib
- Logging
- Notifications by e-mail
See the blog for articles on automssqlbackup.
Requirements
- MS SQL Server (2000+) with SMO libraries installed
- Powershell 1.0
- SharpZipLib
Download
Download the latest version from GitHub.
Change Log
- 090209 Initial Release 0.25
- 090211 Version 0.26: SharpZipLib, Exception handling, option to exclude databases
- 090217 Version 0.27: Notification mail subject contains schedule, error indicator
- 090223 Version 0.28: HTML mail with backup overview
- 090409 Version 0.29: Large file support, no timeout during backup of large databases
- 090731 Version 0.30: Handling server instances, exception messages with stack trace
- 120719 Version 0.31: supports MS SQL Server 2005, 2008, 2012