Command line restore of SQL Server Database

Last post 04-30-2014, 10:28 AM by Pudge. 2 replies.
Sort Posts: Previous Next
  • Command line restore of SQL Server Database
    Posted: 04-23-2014, 10:09 AM

    We recently installed CommVault V10 and are migrating our backups from our old Networker environment.  We would like to replicate the functionality of a database refresh script we currently use with Networker.  The script allows our DBAs to initiate a restore of a SQL server database from the production server to a development DB server.  The DBAs specify the type of backup and the timeframe to restore from.  They are presented with a list of possible savesets and they select the date/time of the desired saveset.  The script then initiates the restore.  The restore portion is only a small part of the script.  The rest of the script makes changes to the DB to make it suitable for the development environment.

     

    I have been reading about qcommands and qscripts.  Can these only be run from the commserv, or can they be run from the client.  I do not see the executables in the file system for the clients.  Our DBAs run the current script from our development database server, but indicated it would be nice if they could initiate it from their desktops.

     

    Can anyone get me pointed down the right path?

     

    Thanks

     

    Brent Wilhelm

    Salisbury University

  • Re: Command line restore of SQL Server Database
    Posted: 04-23-2014, 10:17 AM
    • Ali is not online. Last active: 07-03-2019, 12:32 PM Ali
    • Top 10 Contributor
    • Joined on 08-05-2010

    Hi Brent,

    Hope you are well.

    Yes, one way to do this is by walking thru the GUI as if to run a backup manually, then before you initiate the job, the Restore window has a "Save as Script" option.  This will ouput the CLI syntax that can be used/launched from any machine which can reach the CommServe machine to initiate the job.

    Also you could also chose the Schdule option in the Restore options window to do it in an automated fashion.  There are other ways as well, such as using the Workflow feature in Simpana 10 which gives you vast flexibility to accomplish this via Simpana/native OS/application commands as well.

  • Re: Command line restore of SQL Server Database
    Posted: 04-30-2014, 10:28 AM

    Thanks Ali,

     

    I was able to get a workable solution.

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