Database Appliances : Home page

» SANButler

» dbButler

» controlButler

» BackupButler for SQL Server

» BackupButler for Oracle


» Butler Configurations

» Documentation

BackupButler is an industry first computer system designed to deliver total automated database backup and recovery for Microsoft SQL Server versions 7.0 and 2000, all service packs.

Other Backup and Recovery systems are merely pretenders, asking DBA's to keep manual recovery scripts along with their "automated" software.

BackupButler for SQL Server

BackupButler has the ability to read internal database conditions, store them for safekeeping in it's own recovery database, and change scheduled backup tasks immediately. Microsoft SQL Server has unique backup requirements that must be managed differently depending on the activity that occurs against the database. For example, a non-logged operation will instantly invalidate archive log backups, therefore requiring a full or differential with log file init's to recover. No "automated" tape software available today provides this type of TargetServer scrutiny critical to the safe and reliable operation of your Backup system.

Does your current Backup software keep a fully updated user/role/permissions script available to re-build your server in the case of a complete disaster? Ask the tough questions about your current Recovery capability and you'll be shocked at how vulnerable you are without automated rebuild.

SQL Server:

Take our backup quiz!
Does your current backup plan pass the test? A "NO" to any question here means big trouble:

  • Does your current backup software handle changes inside
    your database that invalidate your backup schedule?
    (do your backups fail sometimes?)

  • Does it save User Id/Login Id linkages?
    (so you can rebuild your server after a disaster?)

  • Does it have a database of current backup information?
    (so backup information is not lost after a disaster?)

  • Does it alert you to non-logged activity?
    (that invalidates your log backups?)

  • Does it encrypt your backup files for security?

  • Does it keep a list of roles and permissions reverse
    engineered at all times?

  • Does it keep a recovery catalog separate from the target
    server for disaster recovery?

  • Are you running hot backups?

  • Are you backing up your logs?
    (current transactions since last full)

  • Are your backups disk to disk? (4-10 times faster
    than tape!)

  • Do your disaster recovery files come from fast disk?

  • Does your backup software schedule groups of servers
    and databases instead of one at a time?

  • Does it prevent you from executing useless backups ?
    (ie. a database backup without the master?)



    These are a small sample of the problems you face with other SQL Server backup products that are now BackupButler automatic.


     Databases
    Backup/Restoral of databases plus their options:
    • Auto options
    • Cursor options
    • Recovery options
    • SQL options
    • State options


     Logins/passwords/permissions
    Backup and restoral of logins/passwords and permissions:
    • Kept by always available always current TSQL scripts stored in the appliance
    • Accounts
    • Privileges
    • Permissions
    • Roles


     Backup Schedule
    • Dynamic schedule maintenance
    • Database condition alerts
    • Rule based backup scheme prevents useless backups


     Global configuration settings for the server
    Server settings stored in the appliance. A partial list :
    • cursor threshold, locks, allow updates, etc
    • collation_seq, identifier_case, etc


     Automatic install agent with no object limits
    • Agent reads all necessary information from TargetServer
    • No limit to the number of servers or databases per server
    • Unique preferences scheme means instant backup schedule generated for entire server at time of Agent install


     Silent operation
    • Local error only logs and 3 error to email preferences
    • Very low overhead always running ButlerAgent
    • Transparent database effect with NOLOCK on all SQL Server catalog requests


     Transaction log backup and recovery
    Transaction log backup is automatically protected:
    • Automatic schedule changes handles non-logged errors
    • Transaction log recoveries with most current automatic

    And Much More
    BackupButler provides a simple browser interface to do all scheduling and monitoring of tasks, password protected.


    Read The case for SQL Server BackupButler PDF

    © 2003 Database Appliances, Inc.

    For more information: sales@databaseappliances.com


    • Specifications

    Hardware Appliance:

    • 24x7 backup information database

    • user friendly interface accessible by a lan browser

    • large network RAID disk farm in 1 TB and 3 TB clusterable frames

    • Butler interconnect maximum of 1000 TB (55 x 7 x 4u Butler racks) always on-line ultrafast disk

    • drastically reduced TCO in comparison to other products

    • automatic Butler to Butler full system mirrors

    • custom scheduling/monitoring software

    • custom backup and recovery scripts

    • maintenance free design architecture

    Host Agent Software:

    • installed as a service on your target host

    • communicates with the hardware appliance unattended

    • features a browser interface to the appliance

    • runs all your scheduled backup and recovery jobs



    True Plug and Play

    Butler Disk write using the direct mount Butler option:



    1. Option (a) TargetServer mounts ButlerDisk cube once via iSCSI and formats iSCSI disk with native Linux or Windows NTFS filesystem. Option (b) ButlerAgent dynamically mounts the disk using NFS (any Unix) or SAMBA (Windows).

    2. ButlerAgent transfers backup file to ButlerDisk.

    3. Transparently, ButlerAgent or ButlerApplianceAgent (depending on the mount option chosen) transfers backup file to Butler internal disk (after manifest).

    4. ButlerAgent deletes backup file from disk mounted on TargetServer after user specified timelimit.

    5. Backup file remains on Butler internal disk until required for recovery, at which time it will be transferred back.

    6. Option (c) Replacing steps 1 and 2. No direct mount occurs and backups are written directly to TargetServer disk and then transferred to the Butler by encrypted TCP/IP pipe.






    Full BackupButler iSCSI use:

    Our iSCSI technology also provides the capability of separate Butler systems to be exact disk mirrors of each other. Disk sync occurs across the local LAN or the world wide WAN. Indeed, iSCSI technology allows you to mount or mirror any portions of the appliance disks in any fashion you chose. The flexibility is yours.

    This Butler SAN capability also allows us to utilize new Raid based / hot swap high capacity ATA drive technology. This results in a disk space cost that is a fraction of what you pay for your current expensive SAN disk. And it's much easier to implement due to our use of copper gigabit instead of Fibre. For example, any Linux or Microsoft Windows Server can now take full advantage of Butler SAN. This gives ALL your computer systems access to our high performance, low cost storage.

    Our systems range in size from 1 TB to 1000 TB (a single Petabyte).

    Download the Appliance Specifications PDF

    If you do not have the PDF Reader,
    get it for free at  Adobe's site.
    ©2003 Database Appliances, Inc. All Rights Reserved.