Database Recovery and Checkpoint

Recovery Model is Full and we make full backup of database
every night. Transaction Log backup is performed hourly.
I would like to know if the system crashes, does it mean
that we can recover the system by restoring
1) Last night full backup
2) Transaction Log since Full Backup ?
Someone mentioned that checkpoints are automatically
created by SQL Server 2000. I would like to know how
checkpoint affect the database recovery procedure ? IF
not, why do we create checkpoint periodically ?You can recover the system to the point of your last log backup using
the process you describe. Checkpoints do not affect your recovery
procedure.
The main purpose of automatic checkpoints is to reduce database recovery
time during system restart. SQL Server can start forward recovery from
the last checkpoint rather than the beginning of the log. See the Books
Online <architec.chm::/8_ar_da2_8y3y.htm> for more information.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Stephen Mak" <anonymous@.discussions.microsoft.com> wrote in message
news:07b701c3af0a$78c2ec40$a301280a@.phx.gbl...
> Recovery Model is Full and we make full backup of database
> every night. Transaction Log backup is performed hourly.
> I would like to know if the system crashes, does it mean
> that we can recover the system by restoring
> 1) Last night full backup
> 2) Transaction Log since Full Backup ?
> Someone mentioned that checkpoints are automatically
> created by SQL Server 2000. I would like to know how
> checkpoint affect the database recovery procedure ? IF
> not, why do we create checkpoint periodically ?|||In addition to Dan's post:
You can do a log backup of a damaged database using the NO_TRUNCATE option of the backup log
command. Even if the whole installation is what, you can get the ldf file to a working SQL Server
and do the procedure on that machine (there's a KB on this).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Stephen Mak" <anonymous@.discussions.microsoft.com> wrote in message
news:07b701c3af0a$78c2ec40$a301280a@.phx.gbl...
> Recovery Model is Full and we make full backup of database
> every night. Transaction Log backup is performed hourly.
> I would like to know if the system crashes, does it mean
> that we can recover the system by restoring
> 1) Last night full backup
> 2) Transaction Log since Full Backup ?
> Someone mentioned that checkpoints are automatically
> created by SQL Server 2000. I would like to know how
> checkpoint affect the database recovery procedure ? IF
> not, why do we create checkpoint periodically ?