The good life in Norfolk, supported by SQL Backup Pro
"I am a Norfolk man and glory in being so." So said Lord Horatio Nelson, architect of Britain's greatest naval victory at the Battle of Trafalgar. More than 200 years later, residents of Norfolk are still justifiably proud of the place they call home.
One of the people working to make Norfolk a great place to live is Kurt Frary, who has managed the county council's IT infrastructure since October 2004. A vital cog in that infrastructure is fast, reliable and safe backups, a task for which Frary relies on SQL Backup Pro from Red Gate Software.
Frary selected SQL Backup Pro for Norfolk County Council's new virtual environment based on SAN storage. Along with internal IT, the new environment supports a wealth of county services on the council's web site, where you can report a faulty streetlight, research schools, find out the best places to enjoy the Norfolk countryside, and even apply for an arts grant.
We didn't have infinite amounts of disk storage for SQL backups, so it was imperative to keep the disk footprint as small as possible. With native SQL backups, that's not possible because compression isn't available.
SQL Backup Pro met our criteria: proven compression ratios, industry-standard encryption levels, and to keep costs down, licenses that are priced per server and not per instance.
Norfolk County Council's infrastructure is based on VMware ESX Virtual SQL 2005 and comprises four virtual servers: one for development, one for test/training, and two for production. Although most of its SQL applications are web-based and less than 50 GB, Norfolk County Council has a Microsoft Operations Manager (MOM) with a current database size of 350 GB. Fortunately, the compression algorithms in SQL Backup Pro have downsized Frary's backup footprint to just 14 GB, a 96 percent reduction.
SQL Backup Pro has cut storage requirements considerably. It is also much cheaper to purchase SQL Backup Pro compared with additional SAN storage disks that would be needed to accommodate increasingly large backup files. Encryption is important due to the sensitivity of information held in some databases. With the choice of either 128- or 256-bit key encryption, we can be sure our databases are secured.
Try a 14-day fully functional free trial of SQL Backup Pro.
Find out more: