Restoring SQL Databases to "dumb files on disk"?

Last post 03-09-2011, 1:16 PM by Paul Hutchings. 6 replies.
Sort Posts: Previous Next
  • Restoring SQL Databases to "dumb files on disk"?
    Posted: 03-05-2011, 9:39 AM

    With the MS SQL Agent, is it possible to restore a database so that it's restored as "dumb files" which the dba can then do as he pleases with?

    We currently backup SQL using the inbuilt SQL backup utility and it produces backups which are portable and which the dba can mount/move/mess with as he wishes.

    Thanks,

    Paul

  • Re: Restoring SQL Databases to "dumb files on disk"?
    Posted: 03-05-2011, 2:30 PM
  • Re: Restoring SQL Databases to "dumb files on disk"?
    Posted: 03-05-2011, 4:39 PM

    Thanks JW, and I had already read that - still not clear which bit of terminology is the commvault/sql equivelent of "just dump the database and t-logs in c:\temp and we'll deal with the rest"?

    Is it the file/file group stuff?

    Thanks,

    Paul

  • Re: Restoring SQL Databases to "dumb files on disk"?
    Posted: 03-06-2011, 2:03 PM

    I would also like to know if this is possible. We do a lot of SQL flat file dumps and id like a compelling reason to move to commvault SQL Agents.

  • Re: Restoring SQL Databases to "dumb files on disk"?
    Posted: 03-08-2011, 1:13 PM

    Anyone please?

  • Re: Restoring SQL Databases to "dumb files on disk"?
    Posted: 03-08-2011, 3:31 PM

    You can accomplish this by following the KB article below.

    With our SQL agent you will need to restore and detach the database from SQL as a different name \ path so it does not affect the production DB.

    The SQL agent can not restore the database to a flat file it must always be restored to SQL but can easily be detached.

    KB below.

    https://ma.commvault.com/KB/Details/11037

    Let me know if this answers your question.

    Patrick


    CommVault Messaging Support
  • Re: Restoring SQL Databases to "dumb files on disk"?
    Posted: 03-09-2011, 1:16 PM

    Thanks very much Patrick.  Not quite the answer I was hoping for but the answer nontheless.

    Paul

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