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/d.../>
rt_6628.asp
or
http://msdn.microsoft.com/library/d...r />
_4hk5.asp

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@hotma
il.com> schrieb im Newsbeitrag
news:2706FFFE-4BD4-42EC-8465- 18A7569B8F60@microso
ft.com...
> 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/d...
tart_6628.asp
> or
> http://msdn.microsoft.com/library/d.../>
te_4hk5.asp
>
> 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:
>