Template scripts for quiescing and unquiescing a user defined application (SQL)


=============================== Application Quiesce Scripts ============================

@ECHO OFF

REM This is an example script of quiescing a user-defined application

REM -- Required Vars
set localhost=becks.devemc.company.com
set shortlocalhost=becks
set GalaxyBaseDir=<software installation path>\Base
set CV_ERRORLEVEL=0

REM -- Use CVSnapTool to quiesce SQL database

REM ------------------------------ cvsnaptool.exe -----------------------------------------
REM arguments: [-x <server>] [-g <storage group>] [-S <remote server>] [-t] [-v <volume>]
REM [-a sql7|sql2000|ex55|ex2000] [-o quiesce|unquiesce|recover] [-vm client name]
REM -x <server> is the exchange server name or the SQL server name
REM -g <storage group> confines an action to a particular group (only exchange 2000).
REM -S <remote server> will call this program on the remote server.
REM -a is the application to quiesce.
REM -o is the operation to perform (recover is only for SQL).
REM -t truncates the logs of the application being unquiesced.
REM -v is the particular volume to quiesce all resources on (SQL only) - can be given multiple times.
REM -N will enable the NORECOVERY option during restore only. Option ignored on backup.
REM ----------------------------------------------------------------------------------------

"%GalaxyBaseDir%\cvsnaptool.exe" -x %shortlocalhost% -a sql2000 -v K: -o quiesce -vm <InstanceName*> -cn <ClientName>
if not errorlevel 0 goto Abort

REM Exit clean
goto Exit

:Abort
echo An error occurred during batch file execution.
set CV_ERRORLEVEL=1
goto Exit

:Exit
@echo off
@echo CV_ERRORLEVEL=%CV_ERRORLEVEL%

==================================================================================


============================== Application Unquiesce Scripts =============================
@ECHO OFF

REM This is an example script of unquiescing a user-defined application

REM -- Required Vars
set localhost=becks.devemc.company.com
set shortlocalhost=becks
set GalaxyBaseDir=<software installation path>\Base
set CV_ERRORLEVEL=0

REM -- Use CVSnapTool to quiesce SQL2000 database

REM ------------------------------ cvsnaptool.exe -----------------------------------------
REM arguments: [-x <server>] [-g <storage group>] [-S <remote server>] [-t] [-v <volume>]
REM [-a sql7|sql2000|ex55|ex2000] [-o quiesce|unquiesce|recover] [-vm client name]
REM -x <server> is the exchange server name or the SQL server name
REM -g <storage group> confines an action to a particular group (only exchange 2000).
REM -S <remote server> will call this program on the remote server.
REM -a is the application to quiesce.
REM -o is the operation to perform (recover is only for SQL).
REM -t truncates the logs of the application being unquiesced.
REM -v is the particular volume to quiesce all resources on (SQL only) - can be given multiple times.
REM -N will enable the NORECOVERY option during restore only. Option ignored on backup.
REM ----------------------------------------------------------------------------------------

"%GalaxyBaseDir%\cvsnaptool.exe" -x %shortlocalhost% -a sql2000 -v K: -o unquiesce -vm <InstanceName*> -cn <ClientName>
if not errorlevel 0 goto Abort

REM Exit clean
goto Exit

:Abort
echo An error occurred during batch file execution.
set CV_ERRORLEVEL=1
goto Exit

:Exit
@echo off
@echo CV_ERRORLEVEL=%CV_ERRORLEVEL%

==================================================================================

* InstanceName is the name used for a Recovery Director instance (by default it is Instance001).