CommVault Forums

Solving Forward - Solving Together
Welcome to CommVault Forums Sign in | Join | Help
in

Simpana 9.0.0 SQL backup and restore questions

Last post 10-19-2012, 10:53 AM by Ron Potts. 3 replies.
Sort Posts: Previous Next
  • Simpana 9.0.0 SQL backup and restore questions
    Posted: 10-07-2012, 11:45 PM

    Hi all,

    I was wondering if someone could please clarify the below for me:

    1. If we want to restore a database which is up and has active connections (i.e. applications have active connections to the DB), does CommVault allow you to perform the restore and kick the connections/start in single-user mode automagically? Or is it a case of having to manually restart the SQL services in single-user mode and then perform the restore as that user?

    2. Does CommVault have anyway to utilize the “WITH CHECKSUM” option for SQL backups, whereby SQL will perform checksum checks during the backup. Not CommVaults verify, as this is just verifying CV’s chunks, rather it is an option with SQL which is also available in other backup products.

    Cheers,
    Will

  • Re: Simpana 9.0.0 SQL backup and restore questions
    Posted: 10-19-2012, 7:09 AM

    Dear Baewill,

                         From my understanding I assure that DB restore is possible in active SQL DB. It is recommended to take VSS enbled backup always. 

  • Re: Simpana 9.0.0 SQL backup and restore questions
    Posted: 10-19-2012, 10:36 AM

    using VSS enabled backups on SQL will limit you restore capabilities.

    With VSS you will not be able to restore out of place or change the file name if you are restoring to the same instance.


    CommVault Messaging Support
  • Re: Simpana 9.0.0 SQL backup and restore questions
    Posted: 10-19-2012, 10:53 AM

    Hi Will,

    In regards to your questions:

    1. If we want to restore a database which is up and has active connections (i.e. applications have active connections to the DB), does CommVault allow you to perform the restore and kick the connections/start in single-user mode automagically? Or is it a case of having to manually restart the SQL services in single-user mode and then perform the restore as that user?

    Response: Currently CommVault will not automatically clear the connections. If the database has active connections too it during the restore, Microsoft SQL will likely return an "Excluse Access Could Not be Obtained" error. We have spoke to development and a Customer Modification request was made for this to provide an option during restore to drop any active connections. They will look into this for a future release of CommVault.

    Answer Title: SQL iDA Restore Fails with Error "Exclusive access could not be obtained.."
    Answer Link: https://ma.commvault.com/KB/Details/10797
     

     
    2. Does CommVault have anyway to utilize the “WITH CHECKSUM” option for SQL backups, whereby SQL will perform checksum checks during the backup. Not CommVaults verify, as this is just verifying CV’s chunks, rather it is an option with SQL which is also available in other backup products.

    Response: This has also been brought up to CommVault development as a customer modification request. They will look into possibly implementing this in a future revision of CommVault.

    In regards to using VSS, as Patrick stated, we would typically recommend agaisnt this with the SQL Server iDA backups due to the restore limitations. The database must be restored back to the same instance it was backed up from. If using the SQL 2005 VSS writer or greater, you can restore it to a different database name and physical path, but cannot rename the MDF and LDF file.

    Thank you,

     


    Ron Potts
    CommVault Messaging Support
The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of CommVault Systems, Inc. ("CommVault") and CommVault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, CommVault.
CommVault, CommVault and logo, the “CV” logo, CommVault Systems, Solving Forward, SIM, Singular Information Management, Simpana, CommVault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of CommVault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2014 CommVault | All Rights Reserved. | Legal | Privacy Policy