search

olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution
https://ola.hallengren.com
MIT License
2.91k stars 756 forks source link

SQL Server Backup support for Cohesity Backups #676

Open JackDonnellWork opened 2 years ago

JackDonnellWork commented 2 years ago

Expand the SQL Backup maintenance process to support Cohesity backups. Thank you

https://www.cohesity.com/solutions/backup-and-recovery/microsoft-sql-server/

Stiffboard commented 3 weeks ago

I've created PowerShell jobs that restored databases (from one servers backup to another servers instance) using ps1 files...this requires you to add password for the user first time and then uses cached password. Hard to see how this can be done with API as you don't want user and password in script. Interested in any solution here.

griffitmatt commented 3 weeks ago

I've created PowerShell jobs that restored databases (from one servers backup to another servers instance) using ps1 files...this requires you to add password for the user first time and then uses cached password. Hard to see how this can be done with API as you don't want user and password in script. Interested in any solution here.

Ola scripts only provide a backup solution not recovery so not sure this is the right place to be asking for help on restore scripts. To offer some help with Powershell script you could look at using the get-credential cmdlt and save the credentials to an encrypted file?

Stiffboard commented 3 weeks ago

Not asking for help. My restore script works fine. Just adding information to the request that it might be difficult to use the Cohesity API for backup as it requires user and password. But maybe there are other ways to get this to work, which I would appreciate. No experience in backing up to Data domain and other third party solutions. This is a bit tricky as it involves two different departments in larger infrastructure environments. I've had to create separate backup monitoring jobs as backup sometimes fail aver time and I want to catch that...which btw would be a candidate to add to a OH add-on script repository.