Lorenzo Benaglia

Storie di un SQLlaro mannaro...
Archivio Posts
Anno 2010

Anno 2009

Anno 2008

Anno 2007

Anno 2006

Anno 2005
luglio 2024

Red-Gate SQL Backup version 4

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
Categoria: SQL Server
mercoledì, 18 gen 2006 Ore. 15.22
  • Views Home Page: 944.584
  • Views Posts: 708.282
  • Views Gallerie: 13.062.566
  • n° Posts: 300
  • n° Commenti: 314

Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003