Dell PowerVault DP600 Manual de usuario Pagina 74
- Pagina / 158
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
74
How to Recover and Rename a SQL Database
How to Recover a Database to a Different Instance of SQL Server
How to Copy a SQL Database to a Network Folder
How to Recover a SQL Database and Allow Additional Log Backups
How to Recover a SQL Database and Allow Additional Log
Backups
The DPM recovery process uses SQL Server functionality to recover a database such that all
uncommitted transactions are rolled back. The recovery process opens the transaction log to
identify uncommitted transactions. Uncommitted transactions are undone by being rolled back,
unless they hold locks that prevent other transactions from viewing transactionally inconsistent
data. This step is called the undo, or roll back, phase.
In some circumstances, the SQL Server administrator might require the database to be restored
in a mode that allows log backups to be selectively played back. Using DPM, you can recover a
database and leave it in a restoring state in which additional log backups can be applied to the
database.
To recover a database without transaction roll back
1.
In DPM Administrator Console, click Recovery on the navigation bar.
2.
Using the browse functionality, select the database to recover.
3.
On the calendar, click any date in bold to obtain the recovery points available for that
date. The
Recovery time menu lists the time for each available recovery point.
4.
On the Recovery time menu, select the recovery point you want to use. You can select
any recovery point except Latest.
5.
In the Actions pane, click Recover.
The Recovery Wizard starts.
6.
On the Review recovery selection page, click Next.
7.
Select Recover to original SQL Server location or Recover to any SQL instance
, and
then click Next.
8.
If you select Recover to any SQL instance, on the Specify recovery destination
page,
specify the instance of SQL Server to which the database should be recovered.
9.
On the Specify Database State page, select Leave database non-operational but
able to restore additional transaction logs.
10.
Select Copy SQL transaction logs between the selected recovery point and latest
available recovery point, specify a copy destination for the transaction logs, and then
click Next.
DPM must have Write permission for the copy destination for the transaction logs.
11.
Specify recovery options for network bandwidth usage throttling, SAN-based recovery,
and e-mail notifications, and then click
Next.
- Abstract 1
- Contents 3
- Managing DPM Servers 9
- In This Section 10
- See Also 10
- Restarting the DPM Server 16
- Renaming the DPM Server 17
- How DPM Displays Times 18
- Managing the Storage Pool 19
- Monitoring DPM Server 22
- Locating Information 23
- Methods for Monitoring DPM 25
- E-Mail Type Subject Line 31
- Workstations 33
- Management Tasks 36
- Exchange 41
- Dismounting Databases 46
- Renaming Storage Groups 47
- Recovering Exchange Data 49
- Recovering Mailboxes 55
- Running SQL 62
- Recovering SQL Server Data 68
- Backups 74
- Windows SharePoint Services 75
- Domains 78
- Running Virtual Server 85
- Renaming Virtual Machines 88
- Moving a Virtual Machine 89
- Moving a Virtual Hard Disk 89
- Managing Performance 93
- Replica Creation 94
- Change Tracking 95
- Synchronization 96
- Consistency Check 96
- Express Full Backup 97
- Backup to Tape 97
- DPM Processes 97
- DPM and Memory 98
- Performance Counters 98
- Performance Object 99
- Indicate a Problem 99
- Possible Causes 99
- Improving Performance 100
- Modifying Workloads 101
- Increasing Capacity 105
- Managing Tape Libraries 108
- Remapping Tape Drives 109
- Removing Tape Libraries 110
- Managing the Tape Catalog 111
- Cleaning Tape Drives 111
- Managing Tapes 112
- How to Identify Tapes 113
- Managing Suspect Tapes 114
- How to Import Tapes 115
- How to View Tape Contents 115
- Rotating Tapes Offsite 116
- How to Copy Tapes 116
- How to Inventory Tapes 117
- Disaster Recovery 118
- System State Backup Logs 122
- Backup of DPM Servers 123
- Recovery 132
- Parameter Description 134
- Recovering DPM Servers 137
- Using DpmSync 139
- Classes Added by DPM 144
- Attributes Added by DPM 144
- Attribute Description 145
- Attribute Value 145
- Alert Types 157
Relacionado con productos y manuales para Hardware De La Computadora Dell PowerVault DP600
(8 paginas)© 2020, manymanuals.es. Todos los derechos reservados | 0.037 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales