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
jeffHi
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:
rt_6628.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
rt_6628.asp
or
_4hk5.asp" target="_blank">http://msdn.microsoft.com/library/d...r />
_4hk5.asp
241g.asp" target="_blank">http://msdn.microsoft.com/library/d...br />
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:
> tart_6628.asp" target="_blank">http://msdn.microsoft.com/library/d...
tart_6628.asp
> or
> te_4hk5.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
te_4hk5.asp
> o_241g.asp" target="_blank">http://msdn.microsoft.com/library/d... />
o_241g.asp
> On restarting SQL server will try and recover any committed transactions
> from the log file.
> John
> "j.goines" wrote:
>