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

#1

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?

#2

Sanctus (mchi55 (AT) hotmail (DOT) com) writes:

Quote:

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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Why does Error log show database restarting everytime a transactionlog backup runs? - 02-11-2008 , 10:00 AM

Re: Why does Error log show database restarting everytime a transaction log backup runs? - 02-11-2008 , 04:28 PM