Regarding table restore in SQL backups

Last post 02-22-2017, 7:12 AM by Ashwin. 4 replies.
Sort Posts: Previous Next
  • Regarding table restore in SQL backups
    Posted: 10-31-2016, 12:23 PM

    Hi Team,

    Is it possible to restore only tables in SQL?We dont want to restore entire DB,we want to restore particular tables in SQL.

    Thanks in advance....

  • Re: Regarding table restore in SQL backups
    Posted: 11-01-2016, 12:41 PM

    I asked question similar to this earlier of Support. I don't believe table restores are available. You would need to restore the disk to the server.

    http://documentation.commvault.com/commvault/v10/article?p=products/sql/restore_adv.htm#Restore_to_Disk

    Then you would need to restore the tables locally.

    https://support.microsoft.com/en-us/kb/321836

  • Re: Regarding table restore in SQL backups
    Posted: 11-02-2016, 6:16 AM

    Hi Shawns,

    Thanks alot for your suggestion.

  • Re: Regarding table restore in SQL backups
    Posted: 11-03-2016, 3:23 PM
    • Ali is not online. Last active: 07-03-2019, 12:32 PM Ali
    • Top 10 Contributor
    • Joined on 08-05-2010

    Hi Ashwin,

    Is this for the Commserve SQL database, or a client that you have the SQL iDA installed?

    You can do this

    http://documentation.commvault.com/commvault/v11/article?p=products/mysql/t_rstr_blcklvl.htm

    & this

    http://documentation.commvault.com/commvault/v11/article?p=products/oracle/c_ora_restoring_oracle_tables.htm

  • Re: Regarding table restore in SQL backups
    Posted: 02-22-2017, 7:12 AM

    Hi Ali,

    Its client with MS SQL agent,we didnt seen any options for table restore.Commvault having only databases and File/file group restore.

    Links you given for mysql and oracle.

    Thanks..

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 © 2020 Commvault | All Rights Reserved. | Legal | Privacy Policy