VeeamON 2024 - Use Code "COMMUNITY10" for 10% Off!
I have several SQL jobs that currently perform nightly (or weekly) restores of a production database on other servers. Since we have now migrated to the Veeam Backup and Replication solution, I am trying to accomplish these same tasks within the Veeam environment. (BTW, we are on Veeam version 11.) I set up the Veeam PowerShell environment as described here https://helpcenter.veeam.com/docs/backup/powershell/getting_started.html?ver=110#remote and wrote a script to perform a database restore (see attached).I ran the script interactively within a PowerShell session and it completed successfully. I ran it again as a Windows Scheduled Task and it worked. However, I can’t get it to run as a SQL Server Agent job. Here’s the error message that I’m receiving:The term 'Start-VESQLRestoreSession' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.Sinc
Every other database in our enterprise is being backed up except for the VeeamBackup database. So, my question is - Should I run a native SQL backup on it? We have been running Veeam Backup & Replication (Version 11) for a few months now. It has been backing up our VMs and SQL databases except for that one. I looked in the job and there’s no reason (e.g., exclusions) listed for omitting this database. I logged a ticket with the HelpDesk but have not heard back from them yet. Have others noticed this problem? If so, how did you address it?Thanks in advance for your help!
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.