Poco fa ho ricevuto una mail da
Kathryn Lye di Red-Gate Software che annuncia il rilascio di
SQL Backup versione 4.
Vi riporto le release notes:
Major new features • Pro and standard editions split
• Remote back up and restore (Pro only)
• 256-bit encryption (Pro only; standard version still has 128-bit encryption)
• Support to SQL Server 2005
• Improved compression algorithm
• Back up File/Filegroup
• Schedule Backup Wizard (can select multiple databases to script in one go)
• New UI
• Log Shipping Wizard
Minor features• Backup and restore history data will be saved in the msdb table instead (as per native SQL Server) as oppose to in a file on disk. This makes it possible to get backup/restore history data from remote servers. The new Activity history grid will display the last few backups and restores, with SQB backups/restores highlighted and includes statistics of the compression achieved and the speed.
• You can determine the age of old backups, and choose when they should be deleted (before or after running the next backup) in hours as well as days.
• You can set to delete SQL Backup log files (stored on disk), older than a certain age.
• Extended stored procedure can now return last SQB error code and last SQL error code.
• Unicode outputs ok in extended stored procedure. This means if you run remotely to a Chinese SQL Server, for example, all outputs in Chinese will be displayed correctly on an English OS if the necessary fonts are installed.
• Can set to send an email only when there's an error.
• Can script to backup multiple databases using, for example, 'BACKUP DATABASES [*]' or 'BACKUP DATABASES [a, b, c]' (similarly for log backups, BACKUP LOGS [*]).
• New keyword EXCLUDE (so you can say, for example, backup all databases except these ones).
• New keyword THREADS to automatically backup to a given number of files, so that the user does not need to name every file in a split backup e.g. BACKUP DATABASE pubs TO DISK = [<AUTO>] WITH THREADS = 2.
• New Job Failures tab, to see scheduled jobs which have caused an error.
• Facility to highlight databases which have not been backed up within a specified amount of time – Backup alerts.
• Removed Tools dialog (MD5# and verify files).
• Scripts are displayed with syntax highlighters.
• A reset button to go back to the original file name format.
• improved support for usage of tags in backup file names
• improved extended stored procedure feedback
• added management dialog for extended stored procedure rights
• added display of server properties
• added support for Unicode text