Service status, Order of applying transaction log backups (2) – HP Serveur lame HP ProLiant BL465c Gen8 User Manual
Page 286
2.
Transaction log backups at point C can be applied after the previous transaction log backup
(point B) is applied.
Recovering the SQL Server database from backup data existing prior to the last backup data
You can recover the SQL Server database from backup data existing prior to the last backup data
when there is a problem in the latest backup data. For example, when you recover the SQL Server
database from the second-last backup data, apply the transaction logs of the second-last backup from
the primary volume to the secondary volume and then apply transaction log backup.
The following figure shows an example of applying a transaction log backup after the last transaction
log obtained for the second-to-last backup from the primary volume to the secondary volume is applied.
By applying the backups as shown in the example, even if a problem exists with the latest backup
data, restoration can be performed to the most recent state, using the second-to-last backup data.
Figure 81 Order of applying transaction log backups (2)
1.
Transaction log backups at point B can be applied after the previous volume backup (point A)
is restored.
2.
Transaction log backups at point C can be applied after the previous transaction log backup
(point B) is applied.
3.
The transaction log backup at point E can be applied after the last transaction log obtained for
the backup from the primary volume to the secondary volume is applied (point C).
SQL Server database requirements for executing commands
To execute the SQL
drmsql
xxx command for operating the server database, the SQL Server service
status, database status and database type must be taken into account. The following explains the
requirements for executing commands:
Service status
Table 97 Relationship between the status of the SQL Server service and the executable command
Service status
Commands
Stopping
Running
(Not applicable)
Executable
drmsqlbackup
Executable
Executable
drmsqlcat
Operation for SQL Server databases
286