Hello,
We’re trying to make a backup on a server using Agent but we’re facing this error message.
Answer
`SQL Server is not available` during Backup
Best answer by regnor
Is only this job having this problem? And if so, is it a managed by agent or managed by server job?
I tried with both but the same error
Ok. If it was a managed by agent job, I also would have thought that it’s the LocalDB, like
I would suggest that you check the event log on both the SQL server and the backup server. Next would be the Veeam logs under %PROGRAMDATA%. Perhaps you’ll find some hints there and if not, contact Veeam support and let them check this setup.
+14Seems like the Veeam configuration database isn't available while the job is running. Is the SQL server hosting that database?
Max M. | Systems Engineer @Veeam | VMCE/VMCA | VeeaMVP 2023 | former Legend & Vanguard
Seems like the Veeam configuration database isn't available while the job is running. Is the SQL server hosting that database?
Hello,
Veeam is using SQL express and i checked the SQL service and seems to be running fine. Shall I restart the server ?
+14Is only this job having this problem? And if so, is it a managed by agent or managed by server job?
Max M. | Systems Engineer @Veeam | VMCE/VMCA | VeeaMVP 2023 | former Legend & Vanguard
+23If you can open a new console and sign into VBR, the DB itself is fine, in which case, at a guess I’d think the localDB deployed by the agent has issues. I’d start by reading the logs from the agent and see what errors are being reported.
Michael Paul - Opinions are my own and do not necessarily reflect the opinion of Veeam | https://micoolpaul.com | Mastodon: @micoolpaul@masto.nu | Bluesky: @micoolpaul.com
+21Along with the logs I would check what apps using SQL have their database on this server. Maybe they are preventing the backup possibly and you could stop them for the backup.
Chris Childerhose - VMCA2024 | VMCE2023 | VMCE-SP2024 | Veeam Vanguard 8* | Veeam Legend 5* | VUG Canada Leader | vExpert 6* | Toronto VMUG Leader | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech
Is only this job having this problem? And if so, is it a managed by agent or managed by server job?
I tried with both but the same error
Along with the logs I would check what apps using SQL have their database on this server. Maybe they are preventing the backup possibly and you could stop them for the backup.
Server is only running Veeam
+21Along with the logs I would check what apps using SQL have their database on this server. Maybe they are preventing the backup possibly and you could stop them for the backup.
Server is only running Veeam
Did you check the VSS writers in windows? Maybe they are causing issues - vssadmin list writers. If any are in error restart the associated service or restart the server if needed.
Chris Childerhose - VMCA2024 | VMCE2023 | VMCE-SP2024 | Veeam Vanguard 8* | Veeam Legend 5* | VUG Canada Leader | vExpert 6* | Toronto VMUG Leader | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech
+7The ERRRORLOG file in Program Files will be helpful.
Its possible it could be resource constraints.
VMCA2022 | VMCE2021/5 | VUG UK Leader
+14Is only this job having this problem? And if so, is it a managed by agent or managed by server job?
I tried with both but the same error
Ok. If it was a managed by agent job, I also would have thought that it’s the LocalDB, like
I would suggest that you check the event log on both the SQL server and the backup server. Next would be the Veeam logs under %PROGRAMDATA%. Perhaps you’ll find some hints there and if not, contact Veeam support and let them check this setup.
Max M. | Systems Engineer @Veeam | VMCE/VMCA | VeeaMVP 2023 | former Legend & Vanguard
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.