Many people use MSSQL Express over Standard edition, because it is free. However, with MSSQL Express you lose backup functionality. The purpose of today's blog is tell you about a great backup utility designed for MSSQL Express, called SQL Backup & FTP.
SQL Backup And FTP creates MS SQL Server database backups, Zips, Encrypts and sends these backups to a folder, FTP, Dropbox, Box, Google Drive, MS SkyDrive or Amazon S3. The utility runs on a flexible schedule and will send e-mail confirmations on job succesess or failures. It also makes full, differential or transaction log backups, runs custom scripts, backs up file folders, and allows for viewing of the results in a browser on the web and much more. It also can backup remote or hosted databases using what is called script backup.
SQLBackupFTP can be used with any SQL Server database that has backups that are required to be sent daily to a remote FTP server. It is most useful for SQL Server Express 2005 and SQL Server Express 2008, since these versions don't have any function for backup. However, it can be used with any version of SQL Server.