Why does Error log show database restarting everytime a transactionlog backup runs?

[Sanctus]

Why does Error log show database restarting everytime a transaction
log backup runs?
It also runs a checkdb as well.

The log backups are scheduled through a maintenance plan.

Is this normal?

[Erland Sommarskog]

Re: Why does Error log show database restarting everytime a transaction log backup runs?

Sanctus (mchi55@hotmail .com) writes:

Why does Error log show database restarting everytime a transaction
log backup runs?
It also runs a checkdb as well.
>
The log backups are scheduled through a maintenance plan.
>
Is this normal?

Sounds like the maintenance plan includes a CHECKDB that sort of thing
as well.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx