Creating the hp dbutil batch files, Single sql server database – HP P6000 Continuous Access Software User Manual
Page 12
If you use multiple instances of HP DButil (for multiple sets of physical LUNs, for example), you must
set the credentials for each HP DButil instance. For a given instance of HP DButil, you need only set
the credentials for the databases that the instance will interact with.
NOTE:
HP DButil only supports SQL server authentication. It does not support Windows authentication.
Creating the HP DButil batch files
When you know which databases must be replicated, you can create the batch files to issue the HP
DButil commands. Two batch files are needed: one to suspend the database and another to resume
it. The actual names of the batch files are not important but
pre.bat
and
post.bat
are used in
the examples in this guide. The following examples show two methods. Each example uses the default
metadata file names, and assumes that the login credentials are set using the
DButil –setcred
command.
Single SQL Server database
In this example, a single SQL Server database and its log files reside on one or more volumes. The
details are as follows:
•
HP DButil is installed in the directory
C:\DButil
•
The server name is:
Server1
•
Named instances are not used
•
The database name is:
TestDB
The following example shows a
pre.bat
file for this configuration.
@ echo off
rem pre.bat file for suspending a single SQL server database
cd \dbutil
dbutil –pre Server1 TestDB
The following example shows a
post.bat
file for this configuration.
@ echo off
rem post.bat file for suspending a single SQL server database
cd \dbutil
dbutil –post Server1 TestDB
Three SQL Server databases on a common set of volumes
In this example, three SQL Server databases and their log files are co-located on a set of volumes.
Details for this example are as follows:
•
HP DButil is installed in the directory
C:\DButil
•
The server name is:
Server1
•
Named instances are not used
•
The first database name is:
TestDB1
•
The second database name is:
TestDB2
•
The third database name is:
TestDB3
•
Login credentials have been established
Creating snapshot backups using HP DButil
12