none
Backup and Restore Tool for SQL Server Fast Track Applicance - 50 TB DB size

    Question

  • Hi,

    Are there any tools or practices that can enable backup/recovery of 48TB fast track appliance meeting the SLA requirements which is about 2 - 3 hours?

    Thanks in Advance,

    Sri Meda


    Wednesday, February 01, 2012 5:38 PM

Answers

  • Hi Srivatsav Meda,

    Regarding to your description, there are many options for you.

    First there is a native backup command with SQL Server, which will allow you to backup database directly on the same data center or over the WAN. If you want to  backup database to a network address, like "\\network_path\db.bak". For the restore to another test server, there is no GUI through Management Studio. Everything has to be done by SQL scripts. With Management Studio, we could not view the contents of any backup file from a remote network address. In a query window, we can run "RESTORE FILELISTONLY FROM DISK = N'\\network_path\db.bak'" to view its contents. Then run "RESTORE DATABASE ..." to restore it to a test database.

    Meanwhile if you are using SQL 2008, you can try to use SQL backup compression. The benefit with this is that backups are smaller and are also generally faster as IO is normally the bottleneck. If you are planning to use SQL backup compression, you might want to check the following articles for configuring your SQL instance to effectively use backup compression:
    http://sqlcat.com/technicalnotes/archive/2008/04/21/tuning-the-performance-of-backup-compression-in-sql-server-2008.aspx
    http://blogs.msdn.com/b/sqlcat/archive/2008/03/02/backup-more-than-1gb-per-second-using-sql2008-backup-compression.aspx

    If you want to use a third party tool as Vr.babu mentioned, you would have to pay a license fee. Check the product documentation of these tools and find out if the features provided by this tool would be beneficial for your environment and needs.

    Regards, Amber zhang

    Wednesday, February 08, 2012 2:10 AM
    Moderator

All replies

  • Quest Light speed it the best backup tool ,it even zips your backup file up to  6 times, example if your database is 6 GB it takes the backup compressed to 1  GB

     

    Virtual restore daves your day in restorig theDB

    • Proposed as answer by vr.babu Thursday, February 02, 2012 9:59 AM
    Thursday, February 02, 2012 9:59 AM
  • Hi,


    Fastness in backup purely depends on the type of media as the backup device.

    by using Backup compression settings you can wrap backup file size and also helps in complete the backup with in your maintenance window.

    But this compression feature only available in Enterprise edition of SQL SERVER.


    Regards JakDBA Please Mark this as Answered if this solves your issue or satisfied with the response.
    Thursday, February 02, 2012 5:41 PM
  • Can you please share some insights on the performance of this tool? My requirement is 48TB database backup. Backup location can be on the same data center or over the WAN.

    Regards,

    Sri Meda

    Tuesday, February 07, 2012 6:35 PM
  • Hi Srivatsav Meda,

    Regarding to your description, there are many options for you.

    First there is a native backup command with SQL Server, which will allow you to backup database directly on the same data center or over the WAN. If you want to  backup database to a network address, like "\\network_path\db.bak". For the restore to another test server, there is no GUI through Management Studio. Everything has to be done by SQL scripts. With Management Studio, we could not view the contents of any backup file from a remote network address. In a query window, we can run "RESTORE FILELISTONLY FROM DISK = N'\\network_path\db.bak'" to view its contents. Then run "RESTORE DATABASE ..." to restore it to a test database.

    Meanwhile if you are using SQL 2008, you can try to use SQL backup compression. The benefit with this is that backups are smaller and are also generally faster as IO is normally the bottleneck. If you are planning to use SQL backup compression, you might want to check the following articles for configuring your SQL instance to effectively use backup compression:
    http://sqlcat.com/technicalnotes/archive/2008/04/21/tuning-the-performance-of-backup-compression-in-sql-server-2008.aspx
    http://blogs.msdn.com/b/sqlcat/archive/2008/03/02/backup-more-than-1gb-per-second-using-sql2008-backup-compression.aspx

    If you want to use a third party tool as Vr.babu mentioned, you would have to pay a license fee. Check the product documentation of these tools and find out if the features provided by this tool would be beneficial for your environment and needs.

    Regards, Amber zhang

    Wednesday, February 08, 2012 2:10 AM
    Moderator