log file at sql server shutdown

hi all,
maybe a poor question, but i cannot test it for myself now.
when i shutdown or stop sql server, will there all logfiles be written in
the databasefiles, the same as a backup will do?
thanks for help
jeff
Hi
It depends on how orderly the shutdown is, in an orderly shutdown a
checkpoint is carried out which will write all dirty pages to disc.
Check out:
http://msdn.microsoft.com/library/de...start_6628.asp
or
http://msdn.microsoft.com/library/de...reate_4hk5.asp
http://msdn.microsoft.com/library/de...ca-co_241g.asp
On restarting SQL server will try and recover any committed transactions
from the log file.
John
"j.goines" wrote:

> hi all,
> maybe a poor question, but i cannot test it for myself now.
> when i shutdown or stop sql server, will there all logfiles be written in
> the databasefiles, the same as a backup will do?
> thanks for help
> jeff
>
>
|||thanks a lot!
jeff
"John Bell" <jbellnewsposts@.hotmail.com> schrieb im Newsbeitrag
news:2706FFFE-4BD4-42EC-8465-18A7569B8F60@.microsoft.com...[vbcol=seagreen]
> Hi
> It depends on how orderly the shutdown is, in an orderly shutdown a
> checkpoint is carried out which will write all dirty pages to disc.
> Check out:
> http://msdn.microsoft.com/library/de...start_6628.asp
> or
> http://msdn.microsoft.com/library/de...reate_4hk5.asp
> http://msdn.microsoft.com/library/de...ca-co_241g.asp
> On restarting SQL server will try and recover any committed transactions
> from the log file.
> John
> "j.goines" wrote: