beautypg.com

Creating the hp dbutil batch files, Single sql server database – HP P6000 Continuous Access Software User Manual

Page 12

background image

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