olahallengren
SQL Server Backup support for Cohesity Backups
Expand the SQL Backup maintenance process to support Cohesity backups. Thank you
https://www.cohesity.com/solutions/backup-and-recovery/microsoft-sql-server/
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.
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?
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.
Does Cohesity provide extended/CLR stored procedures to perform the backups?
I haven't come across. I've only used the PowerShell scripts here on GitHub to schedule restore from prod to test environments. But PowerShell isn't very good as jobsteps in server agent.