Hp XP Array Manager Software Manual de usuario Pagina 294
- Pagina / 564
- Tabla de contenidos
- SOLUCIÓN DE PROBLEMAS
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Restoring an SQL Server database to a primary volume
This section provides an example of recovering an SQL Server database when the backup data is
stored on the secondary volume. This example restores the data from the secondary volume to the
primary volume by resynchronizing the volumes. The operation ID is Operation_A.
Restoring an SQL Server database
To restore the SQL Server database:
1. Check the backup ID of the backup you want to use for restoration.
Check the backup ID of the backup data to be used for restoring. To check the backup ID, execute
the drmsqlcat command on the database server. Here, the predetermined instance (default)
is used as the instance name of SQL Server.
DBServer >drmsqlcat default
INSTANCE: default
BACKUP-ID: 0000000001 BACKUP-MODE: ONLINE INSTANCE: default ORIGINAL-ID: 0000000001
START-TIME:2002/06/01 10:00:00 END-TIME: 2002/06/01 10:03:00 HOSTNAME: DBServer
T DB OBJECT FILE FS DG DEVICE COPY-GROUP
M DB1 METAFILE D:\MSSQL\DBServer\INSTANCE_1\META D: - - -
D DB1 DATAFILE E:\SQL\data1 E: - Harddisk1 VG01,sqlvol01
T DB1 TRANSACT E:\SQL\tlog E: - Harddisk2 VG01,sqlvol01
:
If you perform restoration in units of instances, including a specific database, by executing the
restoration command with the -target option specified, check the restoration target.
2. Create a backup ID file.
To create a backup ID file, execute EX_DRM_BACKUPID_SET with the backup ID.
DBServer > EX_DRM_BACKUPID_SET Operation_A -backup_id 0000000001
3. Restore the data from the secondary volume to the primary volume.
Restore the data by resynchronizing the primary and secondary volumes. To restore the data,
execute EX_DRM_SQL_RESTORE on the database server.
DBServer > EX_DRM_SQL_RESTORE Operation_A -resync
When EX_DRM_SQL_RESTORE is executed with the -undo option specified, restoration is
performed while the database is in the standby status, in which the database is read-only. If the
-undo option is omitted, after restoration, the status of the database changes to loading, and
the database cannot be viewed. Note that the -undo option cannot be used unless the UNDO
file storage directory has been set using the drmsqlinit command.
Also, do not connect to SQL Server while executing EX_DRM_SQL_RESTORE.
4. Recover the SQL Server database.
To recover the SQL Server database, execute the drmsqlrecover or drmsqlrecovertool
command on the database server.
The following shows an example of the drmsqlrecover command and drmsqlrecovertool
dialog box. For details on the drmsqlrecover command or the drmsqlrecovertool dialog box,
see the HP XP7 Replication Manager Application Agent CLI Reference Guide.
Operation for SQL Server databases294
- HP XP7 Replication Manager 1
- DescriptionEditionVersionDate 2
- Contents 3
- Preface26 26
- Application Agent features 27
- Application Agent functions 28
- Restoring data 29
- Cluster support 30
- Managing generations 32
- Journal 38
- Cascade configurations 49
- Multi-target configurations 50
- Allocating metafiles 55
- Using a cluster configuration 58
- CCR configurations 58
- SCR configurations 61
- DAG configurations 62
- Checkpoint files 69
- Using VSS 70
- NA--I*.edb 73
- Cascade configuration 75
- CCR configuration 76
- SCR configuration 77
- DAG configuration 77
- Expanding dynamic volumes 93
- Setting up RAID Manager 98
- Specifying instance numbers 113
- Specifiable val 119
- (default) 119
- DescriptionParameter 119
- Creating dictionary map files 128
- Cluster Groups) 136
- PROMPT> drmclusinit VCS 137
- PROMPT> drmtapeinit 154
- Configuration parameters 155
- Configuration file examples 158
- Creating a list file 160
- File name of the list file 161
- List file storage location 161
- Contents of the list file 161
- (absolute path) 163
- Prerequisite VBScript version 182
- Deletion of unnecessary files 182
- Creating operation IDs 185
- D:VServer_CFSCG_1 188
- M:,N:VServer_CFSCG_1 188
- BACKUP_OBJECT 196
- STORAGE_1VServer_CEXGCG_1 198
- STORAGE_1VServer_COperation_A 198
- Creating a user script 201
- Coding rules for user scripts 202
- Entries in user scripts 203
- Omission 204
- Multiple 204
- Script environment variables 209
- Command execution permission 209
- Examples of user script usage 211
- Application Agent commands 221
- Basic commands 222
- Precautions on operations 225
- Precautions on backup 227
- Precautions on restoration 229
- Precautions when mounting 230
- Command execution conditions 231
- Windows 243
- 5 Operation for file systems 245
- System configuration 246
- Processing flow 247
- Operation for file systems248 248
- Operation for file systems250 250
- Flow of processing 251
- Operation for file systems252 252
- Resynchronizing copy groups 253
- Backing up a file system 253
- Backup using VSS 255
- Operation for file systems256 256
- User script example 260
- ExplanationScript text 261
- Backup execution example 263
- Operation for file systems264 264
- Operations at the local site 266
- Operations at the remote site 267
- Operation for file systems274 274
- Deleting backup data 275
- Operation for file systems276 276
- Service status 286
- Database status 287
- Database type 290
- DBServer > 295
- -copy_size 7 301
- -mount_pt E: 303
- Backing up transaction logs 314
- BKServer > 322
- Locking a copy group 324
- Unlocking a copy group 326
- Operation at the local site 329
- Operation at the remote site 330
- -password password 339
- PROMPT> osql -E 353
- 2> go 353
- Outline of user script files 357
- Sample user script files 358
- DescriptionScript code 360
- PROMPT> 371
- \original-ID_database-ID.dmp 377
- DBServer > del X:\*.dmp 379
- \Operation_A\DB X:\ 379
- Operation flow 381
- Operation example 382
- Back up the databases 390
- Restore the databases 392
- Perform database recovery 393
- Prepare to restart operations 393
- SG1\IS12 419
- BKServer A > 435
- BKServer A > drmtapecat 435
- BKServer B > 453
- BKServer B > drmtapecat 458
- System Configuration 485
- Disk P1, Disk P3 486
- Disk P2, Disk P4 486
- 8 Troubleshooting 503
- OS log information 504
- Application Agent information 505
- RAID Manager information 507
- Other information 508
- Operation details 508
- ExplanationItem 510
- Adjusting trace log settings 511
- Investigating collected data 511
- Troubleshooting512 512
- Troubleshooting516 516
- 9 Support and other resources 517
- Conventions 518
- Server configuration 522
- Storage system configuration 523
- (C:\Windows\horcm1.conf) 525
- (C:\Windows\horcm2.conf) 525
- (DEFAULT.dat) 528
- VG03,VOL31 534
- VG03,VOL32 534
- VG03,VOL33 534
- VG03,VOL34 534
- Application Agent is running 541
- GUI terms 549
- Glossary 551
- Glossary552 552
- Glossary554 554
Relacionado con productos y manuales para Almacenamiento Hp XP Array Manager Software
Almacenamiento Hp StoreAll Storage Manual de usuario
(93 paginas)
(93 paginas)
Philips 017266693 manuals
Owner’s manuals and user’s guides for Outdoor lighting Philips 017266693.
We providing 1 pdf manuals Philips 017266693 for download free by document types: Datasheet
Comentarios a estos manuales