SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Commvault Simpana 9 SQL Backups


Commvault Simpana 9 SQL Backups

Author
Message
Astorre
Astorre
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 350
Hi,

We have an ongoing battle with our Infrastructure Architect, where they would like to incorporate all SQL Backups in the same solution as the server and filesystem backups which uses Commvault Simpana 9.

Our current SQL backups are backed up by the native SQL backups, and then bak file backups taken by Commvault.

In the past we attempted to use Commvault 7 with both SQL and Oracle, however this was a nightmare experience where servers ground to a halt, and restores would fail. I am being reassured that the newest versions is a lot better and we would not experience the same issues.

I along with the Oracle DBA's are very skeptical by this statement due to past issues, and in our experience have found no 3rd party app that better backsup SQL/Oracle than the inbuilt tools.

Has anyone had expereince of using Commvault Simpana 9, and can offer any feedback on experiences?

Thanks
swhaley
swhaley
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 93
I am curious if you received any feedback on this question and did you implement the Simpana solution? We are looking at using Simpana 10 and I am the DBA for SQL Server and Oracle and would like to hear from some real-world experience.



Astorre
Astorre
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 350
Hi,

We created a test lab for both SQL and Oracle using Simpana 9, during the tests we had problems with regards to restoring TDE databases on both Oracle and SQL. Also point in time recovery tended to be hit and miss.

It seemed fine if doing a full nightly backup so we put this on our Tier 3 VM SQL databases, but we experienced problems as seperate team controls the backups and we wern't being alerted on backup failure's. Typically the times we needed to restore were on these occasions.

We have sinced backed up all Oracle and SQL backups to the Tier 1/2 procedure using the Native Tools along with Siampana to backup these individual backup files. We only keep a weeks worth on local/SAN storage. We have found this to be easier and quicker for DB Backup and restores.
maddy192
maddy192
SSC-Enthusiastic
SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)

Group: General Forum Members
Points: 130 Visits: 569
Good job fighting off those backup admins who go for "simple" and "easy" rather than "right" !

At my new place we use Simpana 10 and boy the current admins defend it saying how fast and easy it is. the commserv needs patches and backups fail sometime. Most times it runs okay. But to tell you the truth I do not like it at all. It updates MSDB backup history (of course coz it's just running TSQL ) to be successful and there are no backup files. Well you the dba better get used to checking and knowing commvault report (just look for backups completed with errors) coz commvault may have had problems *writing* the backup file (Not .bak file mind you..it has it's own proprietary backup file). I mean I am not saying native guarantees if msdb shows backup successful the file would be on disk - but I just feel much more confident with native !
DeWayne_McCallie
DeWayne_McCallie
SSC Eights!
SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)

Group: General Forum Members
Points: 819 Visits: 1205
The problem is when CV has issues and it will have issues at some point usually on a weekend or Holiday - for example the MediaAgent is down or tape drives crap out, no spare scratch tapes in the library etc... = No DB BACKUPS.

If CV is doing TLog backups too then your Log Files autogrow (if enabled) and you could fill up the disk grinding your DB to a halt. Then you have to go shrink all of the TLogs back down to size AFTER you finally get them backed up again. You can point the finger at the backup guys; however, ensuring the recoverability of the DBs are still the responsibility of the DBA...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search