- Posts: 213
- Liked: 26 times
- Joined: Feb 01, 2012 7:24 am
- Full Name: Espen Dykesteen
I have been scratching my head for a while now with surebackup failing on SQL server, and opened a ticket (Case # 01846817).
Just confirmed that the SQL-VM's that are failing our surebackup with error 6 all had offline databases.
This was no problem with previous version of veeam who "just" used the Veeam.Backup.ConnectionTester.exe to test connectivity to port 1433.
But after the introduction of Veeam.Backup.SqlChecker.vbs this causes the application script to fail.
Detaching the DB’s OR bringing them online again (and backing up again) will make surebackup return a scucess for that SQL server.
However it is not that important to have the DB's offline, but sometimes, it can be practical.
Meaning that the following surebackup will fail.
I would like to see that surebackup did not FAIL on offline databases, because that is their state also in production.
So the result is expected. Off cause since I now know this, I could make custom versions of Veeam.Backup.SqlChecker.vbs for the servers with offline databases and skip checking these databases, but that means “micro managing”.
However i would say that if the databae is offline the script should just ignore it. At least not throw an error. Because you are not able/supposed to connect to the DB even in production.
I don't know what Veeam view on this.
- Posts: 1
- Liked: never
- Joined: Oct 15, 2018 3:03 pm
- Full Name: Matt Peterson
I was able to fix this issue by extending the "Application initialization timeout" setting from 120 seconds to 240 seconds. This setting is located in the SQL Server's VM Options (select VM and click Edit...) when configuring the Application Group under SureBackup.
After making that change, the test script ran successfully. If the database or SQL Server Service on the restored VM hasn't had a chance to fully initialize, it would mimic an offline database issue.
I hope that can help someone else!
- Posts: 66
- Liked: 2 times
- Joined: Sep 17, 2010 4:37 am
- Full Name: Ole Thomsen
- Posts: 1
- Liked: never
- Joined: Jan 09, 2019 1:23 am
- Full Name: S Harding
Foggy, can you confirm the fix for handling offline database files will definitely be included in U4?
My understanding from support on my open case 03350192 is that U4 is due toward the end of January 2019.
You indicated the fix "should" be included in U4.
Since this is just a .vbs script file, would it be possible to simply provide us with the updated .vbs file so that we can test this prior to the release of U4?
- Veeam Software
- Posts: 18251
- Liked: 1559 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
Users browsing this forum: No registered users and 34 guests