Misunderstanding this distinction can account for significant loss of time during a
restore process.
RESTORE is a T-SQL command that recreates a database or a portion of a database
from a backup file created with the T-SQL BACKUP command. It has nothing to do with
changing the state of a database, such as offline or online.
Recovery is the process of bringing a database from an offline or restoring state to
an online state in which the database is available for use again. Recovery occurs every
time SQL Server starts. Before bringing any database online during a startup, SQL
Server checks each database??™s transaction log for committed and uncommitted transactions.
If it finds any committed transactions after the last checkpoint is performed, it
???rolls??? them forward. It automatically rolls any uncommitted transactions back. The
same thing occurs during a restore operation. Once the database is brought back to an
online status, no further database files may be restored.
THE DATABASE MYTH OF THE MASSIVE DELETE
I??™ve heard this story a number of times, and it has the taste of an urban myth (???I know a guy whose
brother .
Pages:
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123