Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Comm vault file system sql server backup Expand / Collapse
Author
Message
Posted Thursday, March 3, 2011 3:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 11, 2014 11:05 PM
Points: 8, Visits: 193
Hi ,

i would like to know is it possible that to take the mdf and ldf files using the comm vault files system backup, ina disaster senario can we use the physical backed up ( filesystem) files, Please help me on this...
will we be able to use them with a minimum data loss ?
Post #1072978
Posted Friday, March 4, 2011 4:50 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 19, 2014 12:04 PM
Points: 328, Visits: 3,624
Why not test it on your DEV system?
You should be testing backup restores on a regular basis anyway. If you have to do a DR restore due to dataloss and you've not verified your backups, and they turn out to be useless, this could well have disasterous consequences for both your career and your company.


I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Post #1073200
Posted Wednesday, March 9, 2011 9:24 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 1:02 PM
Points: 1,414, Visits: 4,545
why not just use the SQL agent they have? with netbackup you can do this and if you have the open file agent it will probably work. but life is so much easier if you just use the db agent they ship to run your backups

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #1075652
Posted Wednesday, March 9, 2011 10:08 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 1, 2014 7:26 AM
Points: 908, Visits: 2,804
We've just recently started using CommVault and run some DR testing scenarios. What we have found is that given our environment (VMWare servers. etc.) the best option for DR is the full CommVault file system/ VM snapshotting restore. Otherwise you run into all kinds of issues with versioning, etc.

But yes, definitely test out your DR scenarios as each shop is different.
Post #1075693
Posted Wednesday, March 9, 2011 10:33 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 1:02 PM
Points: 1,414, Visits: 4,545
haven't used it, but i heard the new vmware backup methods where you can backup the entire instance and version it is very nice

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #1075712
Posted Thursday, March 10, 2011 11:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 11, 2014 11:05 PM
Points: 8, Visits: 193
Hi Andrew,

thanks for your comments , i had tested the native sqlidata agent backups to get restored , i could do restore successfully and check the integrity of the database.

to add up to this ... when the files are on line ( mdf and ldf ) and backing up through the comm vault file system, will these backups can be restored successfully.

thanks,
Shiv
Post #1076471
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse