Lorenzo Benaglia


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

Anno 2009

Anno 2008

Anno 2007

Anno 2006

Anno 2005
Calendario
dicembre 2024
lmmgvsd
2526272829301
2345678
9101112131415
16171819202122
23242526272829
303112345

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
Statistiche
  • Views Home Page: 969.707
  • Views Posts: 716.799
  • Views Gallerie: 13.870.455
  • n° Posts: 300
  • n° Commenti: 314
Mappa





















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