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:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_start_6628.asp
or
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_4hk5.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_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...
> 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/default.asp?url=/library/en-us/adminsql/ad_1_start_6628.asp
> or
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_4hk5.asp
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_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
>>