MS SQL Server - log file at sql server shutdown

Author

log file at sql server shutdown

j.goines

2006-01-31, 3:23 am

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

John Bell

2006-01-31, 3:23 am

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..._start_6628.asp
or
http://msdn.microsoft.com/library/d...create_4hk5.asp

http://msdn.microsoft.com/library/d..._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
>
>
>

j.goines

2006-01-31, 7:23 am

thanks a lot!
jeff

"John Bell" < jbellnewsposts@hotma
il.com> schrieb im Newsbeitrag
news:2706FFFE-4BD4-42EC-8465- 18A7569B8F60@microso
ft.com...[color=darkred]
> 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..._start_6628.asp
> or
> http://msdn.microsoft.com/library/d...create_4hk5.asp
>
> http://msdn.microsoft.com/library/d..._ca-co_241g.asp
>
> On restarting SQL server will try and recover any committed transactions
> from the log file.
>
> John
>
> "j.goines" wrote:
>

Sponsored Links