COHESITY for Backup/Restore?

  • daniel.dolan

    Old Hand

    Points: 373

    Any one have any experience with using Cohesity as the backup/restore platform instead of doing native SQL backups? With TSM, we always did a SQL backup, and then swept that up to tape. In our new backup system based on Cohesity, my backup admins want to backup up the database and log files directly from their system, but I still remember that doing so used to be a resume generating practice. Our installation engineer is telling me that what is happening under the covers is a regular SQL backup, just the destination is the Cohesity storage which is then moved to tape.

    Any thoughts?

  • Grant Fritchey

    SSC Guru

    Points: 396339

    I never argue on these things. I just ask them to demonstrate a point in time restore that meets both our business defined Recovery Point Objective and Recovery Time Objective. If they can do it. Great. We're done. If they can't, we're not using that tool because I have to meet the RPO & RTO. It's not a fight. It's simple logic. Get them to show you how they can meet the RPO & RTO (and check the database integrity when they're done). If they can't, smile, say thanks playing, and go about your day.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Jeff Moden

    SSC Guru

    Points: 995687

    Along with what Grant has stated and since they said it did "regular" SQL Backups, have them do a test restore using native tools only to prove it's a regular backup.

    Also ask to see the plan for doing test restores of different databases on a regular basis as well as the DR Test Plan where they pretend the build the prod box is in was wiped off the face of the Earth, all replication had failed, and you need to stand up the DR Test site only from backups.

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Grant Fritchey

    SSC Guru

    Points: 396339

    Jeff Moden wrote:

    Along with what Grant has stated and since they said it did "regular" SQL Backups, have them do a test restore using native tools only to prove it's a regular backup.

    Also ask to see the plan for doing test restores of different databases on a regular basis as well as the DR Test Plan where they pretend the build the prod box is in was wiped off the face of the Earth, all replication had failed, and you need to stand up the DR Test site only from backups.

    Yes to all this.

    There should never be a fight as to what backup tool to use. It's all about meeting the restore and recovery requirements. Period. If they can. Great. If they can't. No, we're not using that.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • This was removed by the editor as SPAM

  • Sue_H

    SSC Guru

    Points: 90552

    MARCOCH wrote:

    to be a resume generating practice. Our installation engineer is telling me that what is happening under the covers is a regular SQL backup, just the destination is the Cohesity storage which is then moved to tape.

    Another spammer. This one and another one just go back and update their posts and embed links in the updates. Go fix that Grant 🙂

    Sue

  • Summer90

    SSC-Dedicated

    Points: 32826

    We just got Cohesity.  I was working with a server engineer on what this means to SQL Server.

    I had a TEST SQL Server 2014 that we did some tests on.  Cohesity was able to, behind the scenes, do a byte by byte backup of the actual server and then we shut it completely down and brought it up in its entirety in the Cohesity VM Host environment.  SQL Server started and appeared OK and the application databases were accessible.  However, I then restored all of the databases with our other SQL Server backup toolset.   Integrity checks ran just fine.  I wish I would have thought to run integrity checks before I restored the databases though.  Our next test was to utilize the Cohesity supplied SQL Server backup/restore process.  Something wasn't working correctly though because it would run the backups and I saw them complete in the SQL Server logs but the tool did not see the backups so we could not restore them.  We were going to call Cohesity support but got working on other things and just never got back to it.

  • Grant Fritchey

    SSC Guru

    Points: 396339

    I'd bet back around to it. Knowing, through valid and successful tests, that you can restore your individual databases per the business RTO & RPO is the only way to know for sure that you can recovery in a disaster.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply