Hello,
i have seen the posts for the prefreeze scripts ,i tried these but it doesnt work.
What i am trying to do is to stop a Sybase DB when the backup starts and then to start it again.
echo
echo %DATE%
echo %TIME%
set datetimef=%date:~-4%_%date:~3,2%_%date:~0,2%__%time:~0,2%_%time:~3,2%_%time:~6,2%
echo %datetimef% >> c:\vadp.log
if "%1%" == "" goto noparam
if "%1%" == "freeze" goto freeze
if "%1%" == "thaw" goto thaw
if "%1%" == "freezeFail" goto freezeFail
goto wrongparam
:freeze
REM before snapshot
echo "Freeze" >> %datetimef%
REM net stop "Sybase"
goto end
:thaw
REM after snapshot
echo "Thaw" >> %datetimef%
REM net start "Sybase"
goto end
:freezeFail
REM snapshot failed
echo "freezeFail" >> %datetimef%
goto end
:noparam
REM invalid program usage
echo "Parameter not specified" >> %datetimef%
goto end
:wrongparam
REM invalid program usage
echo "Invalid parameter" >> %datetimef%
:end
echo "End reached" >> %datetimef%
When i am doublecklicking it makes only thelog with date and time.Normal but when veeam starts the backup it doesnt shut down the Service.Enabled is AAIp and vmware tools quiscence.
The script are in Windows folder and also at vmware tools folder.
is there anything that i should do?
John, in fact, you need to disable application-aware image processing, if you're using pre-freeze/post-thaw scripts, and have only VMware tools quiescence enabled.
Also, it might be worth checking whether the scripts will be triggered by VMware itself. Create a VM snapshot manually with quiescence enabled and see whether the scripts are executed. Thanks.
i have tried without AAIP and the backup wasnt succesful.It stopped.
Is the script right.?
I am trying that with MS SQL service because i dont have the sybase.it is for a customer.i wanted to see if that script stops the sql service.
As mentioned, you should disable AAIP, so that, the VMWare native quiesce is used. Can you elaborate on what specific errors you got? Also, I doubt that scripts written for Sybase would work in case of MS SQL due to underlying differences. Thanks.
i meant that where sybase is in script i use SQL Server.
Deselected the AAIP cant do backup of that VM,vmware tools quiscence is enabled.It hasnt got heavy workload this vm that i am trying to test.
Should i change something else at the script?
i meant that where sybase is in script i use SQL Server.
You should check sybase script against sybase database and see whether the database gets frozen correctly. If it does, then, check whether the scripts can be executed by VMware properly (manual snapshot with quiescence enabled). Then, if everything looks good, but VB&R still is unable to trigger pre-freeze/post-thaw script, open a ticket with our support team and let them investigate it directly.
Should i change something else at the script?
From my perspective, Sybase community might have a better understanding in regards to sybase freeze/thaw scripts.
I believe your issue is similar to this one. Anyway, without AAIP VB&R takes snapshot in the same manner as VMware does. So, I'm wondering what happens if you just take the snapshot manually (quiescence enabled), using vSphere Manager. Will you be able to do so? Thanks.