This process is usually referred to as a checkpoint. You can force a checkpoint to
occur by simply issuing the command CHECKPOINT; otherwise, the checkpoint frequency
will be determined by the database setting RECOVERY INTERVAL. You can adjust this with
the sp_configure command:
Sp_configure 'Show Advanced Options' ,1
Sp_configure 'Recovery Interval' , 5
RECONFIGURE WITH OVERRIDE
Sp_configure 'Show Advanced Options',0
This example changes the checkpoint process to occur every five minutes. By default,
the recovery interval is set to 0, meaning SQL Server dynamically manages how often a
checkpoint occurs. The higher the value, the longer the roll-forward portion of recovery
will take.
CHAPTER 3 n RESTORING A DATABASE 46
Once the roll-forward is complete, the rollback operation occurs, removing uncommitted
transactions from the transaction log. When fast recovery is available (Enterprise
Edition only), the database is considered recovered and available for incoming requests
while the rollback process occurs.
T-SQL??™s RESTORE Command
T-SQL??™s RESTORE command can provide all sorts of functions??”not just replacing database
files.
Pages:
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128