Post reply

Anyone use SQL Backup from Red-Gate for your critical production databases

  • April 21, 2005 at 9:02 am

    #85949

    Has anyone use SQL Backup software from Red-Gate for your critical production databases? What size of is your databases? Do you feel comfortable/confident about it?

  • April 21, 2005 at 10:56 am

    #554152

    I use litespeed but I don't suppose that is much use? Does red gate offer any advantages?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • April 22, 2005 at 8:47 am

    #554360

    SQLBackup works well and the price is remarkable. Both Litespeed and SQLBackup offer compressed and encrypted backup options. Litespeed is cluster-aware, is faster, and offers enterprise management interface. SQLBackup offers neither in its current version. Instead, backup jobs must be set up manually on each server.

    I gave SQLBackup a serious trial recently because of its price per server, and except for the lack of an enterprise-level GUI, I liked it. The support staff at Red-Gate is top-notch. I intended to purchase SQLBackup because we could not afford Litespeed until the Imceda rep made us a deal that we could not refuse.

  • May 16, 2005 at 7:35 pm

    #559158

    SQL Backup has been cluster-aware since the initial release of version 3.0.  Other usability features include

    • multiple trx log restores from a single command e.g. RESTORE LOG mydb FROM FILE = 'F:\BACKUPS\mydb\*_log.sqb'
    • mail notification (via SMTP) only upon error e.g. BACKUP DATABASE mydb TO DISK = 'F:\BACKUPS\mydb.sqb' WITH MAILTO_ONERROR='me@me.com'
    • mirrored backup e.g. BACKUP DATABASE mydb TO DISK = 'F:\BACKUPS\mydb.sqb' WITH MIRRORFILE = 'G:\BACKUPS\mydb.sqb', MIRRORFILE = 'H:\BACKUPS\mydb.sqb'
    • option to copy backup files to an alternate location upon backup completion e.g. BACKUP DATABASE mydb TO DISK = 'F:\BACKUPS\mydb.sqb' WITH COPYTO='\\remoteserver\BACKUPS'
    • and in case you missed it, a TSQL-like syntax that closely resembles standard TSQL, with extensions

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply