HP P6000 Continuous Access Software - Manual (Page 11)

2 Creating snapshot backups using HP
DButil
Procedure
To back up an SQL Server database using snapshots or snapclones and HP DButil:
1. Determine which databases need to be backed up.
2. Set the necessary login credentials (optional).
3. Create the HP DButil batch files to suspend and resume the desired databases.
4. Determine which volumes need to be replicated.
5. Construct the HP Replication Solutions Manager job, or Windows batch files to replicate the
volumes identified in
Step 4 .
6. Test the job.
Determining which databases require backup
Consider the following when choosing databases to be backed up:
• Write operations to the database are suspended for the duration of the snap creation. It typically
takes 10 to 20 seconds per snapshot or snapclone but can be longer.
• You can use HP DButil to prepare any SQL Server database for backup, but you must use HP
Replication Solutions Manager to create the snapshot or snapclone.
• When you start a snapshot backup, you cannot start another backup until the first one has com-
pleted. If you need multiple jobs to back up multiple databases, ensure HP DButil operations do
not overlap.
Setting credentials
Regardless of how HP DButil is used, the recommended first step is to establish login credentials for
each database. The alternative is to specify a user name and password in the HP DButil batch files.
1. Open a DOS window on the host where SQL Server is installed.
2. Navigate to the directory where HP DButil is located.
3. For each database to be replicated using HP DButil, execute the following command:
DButil –setcred
This command stores the authentication information in a lock box file so that it is not needed in each
HP DButil command. If you change the user name or password after setting the credentials, use
DButil –setcred again to update the information in the lock box file.
HP StorageWorks DButil user guide 11