Hp P6000 Continuous Access Software Manual do Utilizador Página 1

HP StorageWorks DButil user guideAbstractThis guide describes procedures for installing, configuring, and managing HP StorageWorks DButil. It is inten

DButil –pre <sqlserver_name\instance> <database_name> <username> <password>Database names that contain spacesEnclose the datab

2 Creating snapshot backups using HPDButilProcedureTo back up an SQL Server database using snapshots or snapclones and HP DButil:1. Determine which da

If you use multiple instances of HP DButil (for multiple sets of physical LUNs, for example), you mustset the credentials for each HP DButil instance.

The following example shows a pre.bat file for this configuration.@ echo offrem pre.bat file for suspending multiple SQL Server databasescd \dbutildbu

exec sp_helpdb TestDB3testdb3_Data H:\SQLdata\testdb3_Data.MDFtestdb3_Log E:\SQLlogs\testdb3_Log.LDFIn this case, the logs file

E7: DeleteHostVolume ( $HV2 ) onerror pauseat E7:E6: DeleteHostVolume ( $HV1 ) onerror pauseat E6:E5: DeleteStorageVolumes ( $Rep4 ) onerror pauseat E

//// Rollback.DeleteReplicaRepository ( $Repository1, FALSE )E4: UnmountHostVolume ( $MP1 ) onerror pauseat E4:E3: DeleteHostVolume ( $HV1 ) onerror p

////// Rollback.DeleteReplicaRepository ( $Repository1, FALSE )E4: UnmountHostVolume ( $MP1 ) onerror pauseat E4:E3: DeleteHostVolume ( $HV1 ) onerror

Figure 2 Managed set of containers monitor job.For more information on creating a managed set of containers for host volumes, see the HPStorageWorks R

Figure 3 Select Replication options.d. Click Suspend Host Application I/O and click Next. Figure 4 displays the Suspend HostApplication I/O window tha

Legal and notice information© Copyright 2005-2009 Hewlett-Packard Development Company, L.P.Confidential computer software. Valid license from HP requi

// Assign some variables that will be used in this job.$source_host1 = SetVariable ( " Production Server IP " )$mount_host = SetVariable ( &

dbutil -pre sqlserver_name database_name username passwordIF %ERRORLEVEL% NEQ 0 goto ErrHand1paircreate -g db_group1 -vlIF %ERRORLEVEL% NEQ 0 goto Err

Creating snapshot backups using HP DButil22

3 SQL Server recovery using HP DButilRecovery approachesThe appropriate recovery method depends on the situation and the type of backup. Choosing anin

a single database needs to be restored and other databases also reside on the volume. There aretwo ways that selective file replacement can be accompl

8. Add the snapclone volumes as cluster resources and SQL Server cluster dependencies.9. Start the SQL Server cluster service.10. Run the DButil –rest

9. Run the DButil –restoresns command to restore the database. You will receive a promptto replace the files.10. Unpresent the failed database disks f

6. Acknowledge the HP DButil file replacement prompt. This completes the restoration and leavesthe database in a loading state. In the loading state,

SQL Server recovery using HP DButil28

4 Troubleshooting HP DButilStatus and error messages are written to an HP DButil log file each time the HP DButil utility is run.These log files can h

Contents1 Using HP StorageWorks DButil ... 7Prerequisites ...

Check the directory that HP DButilis installed to make sure the*.meta file exists. Rename themetadata file to match thesqlserver_dbname.meta. Thiscan

5 Support and other resourcesContacting HPHP technical supportTelephone numbers for worldwide technical support are listed on the HP support website:

Related informationDocumentationFor documents referenced in this guide, see the Manuals page on the Business Support Center website:http://www.hp.com/

Typographic conventionsTable 2 Document conventionsUsesConventionCross-reference links and email addressesBlue text: Table 2Website addressesBlue, und

Support and other resources34

IndexBbatch files, 12Cconventionstypographic, 33Ddatabase backupscreating, 11requirements, 11database names, 10DButilerror messages, 29DButil commands

transaction logsapplying, 24backup, 21troubleshooting DButilerror messages (table), 29typographicconventions, 33Vvolume replacement, 23volume replicat

Recovery scenario 1 ... 24Recovery scenario 2

FiguresSQL database drive example ... 171Managed set of containers mo

TablesTroubleshooting HP DButil error messages ... 291Document conventions ...

1 Using HP StorageWorks DButilHP StorageWorks DButil is a command-line utility to facilitate application-consistent replication of aMicrosoft SQL Serv

Running the utilityHP DButil is run from a Windows command line, typically using the following methods:• Windows batch files• HP Replication Solutions

IMPORTANT:When freezing databases using DButil, follow the best practices for snapshot creation described in SQL Server2005 Virtual Backup Device Inte