Solved

CommVault SQL Server Database Restore

Posted on 2009-05-14
2
1,616 Views
Last Modified: 2013-11-10
Is it possible to restore a CommVault SQL database backup via the query analyser window within SQL  Server ?
Scenario:
CommVault  has taken a backup of my SQL Server databases and place them on the san.
I want to restore 1 of the databases from within the SQL Server ie Query Analyser  So not using the CommVault GUI
Is this possible?
0
Comment
Question by:TAB8
2 Comments
 
LVL 6

Accepted Solution

by:
squify earned 500 total points
ID: 24391616
The only way of doing that is to restore the SQL database using the CommVault GUI to another SQL server then dump the database using SQL tools then use the Query Analyser to bring the database back in to the original SQL server. Never heard of anyone actually doing that as it is so simple doing a restore using CommVault.
0
 
LVL 10

Author Closing Comment

by:TAB8
ID: 31581734
This was a solution just repeating what i already knew. I want to know how to do the Comvault restore without using the agent ..   this solution suggests using the agent .. to no use the agent  ?  ..  but thanks for taking the time to respond hence the points  
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now