Hp XP Command View Advanced Edition Software Manuel d'utilisateur Page 392
- Page / 574
- Table des matières
- DEPANNAGE
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
sp_replicationdboption 'database-name', 'sync with backup', 'true'
For the database-name argument, specify the name of the publication database or distribution database.
How to check the 'sync with backup' option
To ensure that the option has been set, execute the following SQL statement:
select databasepropertyex('database-name', 'IsSyncWithBackup')
For the database-name in the SQL statement, specify the name of the publication database or
distribution database.
When this SQL statement is executed, one of the following values is returned:
If the 'sync with backup' option has been set: 1
If the 'sync with backup' option has not been set: 0
Backing up and restoring in an SQL Server AlwaysOn
availability group configuration
When using Application Agent on an SQL Server in an AlwaysOn availability group configuration,
you can back up and restore user databases on the active node. Backing up and restoring system
databases or backing up and restoring user databases on the passive node are not supported.
System configuration
When using Application Agent on an SQL Server in an AlwaysOn availability group configuration,
you can perform the following:
1. Back up and restore user databases to the active server
2. Restore user databases to the standby server from the active server
3. Restore user databases to the secondary-use server from the active server
The following figure shows the system configuration. The numbers used in the figure correspond to
the numbers above.
Operation for SQL Server databases392
- Part number: TB584-96073 1
- Eighth edition: May 2013 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
- Using VSS 70
- 30 minutes5100 GB 73
- • CPU: 3.0 GHz x 2 73
- • Memory: 4 GB 73
- • Storage system: HP P9500 73
- NNAA--I*.stm 74
- Cascade configuration 76
- CCR configuration 77
- SCR configuration 78
- DAG configuration 78
- Expanding dynamic volumes 94
- Setting up RAID Manager 100
- Specifying instance numbers 115
- Specifiable val 120
- (default) 120
- DescriptionParameter 120
- Creating dictionary map files 129
- Cluster Groups) 136
- PROMPT> drmclusinit VCS 137
- Configuration parameters 155
- Configuration file examples 158
- Creating a list file 159
- VG01,dev01 160
- VG01,dev02 160
- File name of the list file 161
- List file storage location 161
- Contents of the list file 161
- (absolute path) 162
- Prerequisite VBScript version 181
- Deletion of unnecessary files 181
- Creating operation IDs 184
- BACKUP_OBJECT 190
- DBServer_A 192
- DBServer_B 192
- STORAGE_1VServer_CEXGCG_1 197
- Creating a user script 201
- Entries in user scripts 202
- Omission 204
- Multiple 204
- Script environment variables 208
- Command execution permission 208
- Examples of user script usage 210
- Application Agent commands 219
- Basic commands 220
- Precautions on operations 223
- Precautions on backup 225
- Precautions on restoration 227
- Precautions when mounting 228
- Command execution conditions 229
- Windows 241
- 5 Operation for file systems 243
- System configuration 244
- Processing flow 245
- Operation for file systems246 246
- Operation for file systems248 248
- Flow of processing 249
- Operation for file systems250 250
- Resynchronizing copy groups 251
- Backing up a file system 251
- Backup using VSS 253
- Operation for file systems254 254
- User script example 258
- ExplanationScript text 259
- Backup execution example 261
- Operation for file systems262 262
- Operations at the local site 264
- Operations at the remote site 265
- Operation for file systems272 272
- Deleting backup data 273
- Operation for file systems274 274
- Service status 284
- Database status 285
- Database type 288
- DBServer > 293
- -copy_size 7 299
- -mount_pt E: 301
- Backing up transaction logs 312
- BKServer > 320
- Locking a copy group 322
- Unlocking a copy group 324
- Operation at the local site 327
- Operation at the remote site 328
- -password password 337
- PROMPT> osql -E 351
- 2> go 351
- Outline of user script files 355
- Sample user script files 356
- DescriptionScript code 358
- PROMPT> 369
- \original-ID_database-ID.dmp 375
- DBServer > del X:\*.dmp 377
- \Operation_A\DB X:\ 377
- Operation flow 379
- Operation example 380
- Back up the databases 388
- Restore the databases 390
- Perform database recovery 391
- Prepare to restart operations 391
- Cold backup 413
- Online backup 414
- SG1\IS12 424
- BKServer A > drmtapecat 439
- BKServer A > 439
- BKServer B > 457
- BKServer B > drmtapecat 462
- System Configuration 489
- Disk P1, Disk P3 490
- Disk P2, Disk P4 490
- 8 Troubleshooting 507
- OS log information 508
- Application Agent information 509
- RAID Manager information 511
- Other information 512
- Operation details 512
- ExplanationItem 514
- Adjusting trace log settings 515
- Investigating collected data 515
- Troubleshooting516 516
- Troubleshooting520 520
- Troubleshooting524 524
- 9 Support and other resources 525
- Conventions 526
- Server configuration 530
- Storage system configuration 531
- (C:\Windows\horcm1.conf) 533
- (C:\Windows\horcm2.conf) 533
- (DEFAULT.dat) 536
- VG03,VOL31 542
- VG03,VOL32 542
- VG03,VOL33 542
- VG03,VOL34 542
- Application Agent is running 549
- GUI terms 557
- Glossary 559
- Glossary560 560
- Glossary562 562
Produits connexes et manuels pour Stockage Hp XP Command View Advanced Edition Software
(116 pages)© 2020, manymanuals.fr. Tous droits réservés | 0.030 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels