MSSQL2000

[SV CENTRALI]

in a cluster enviroment,in windows 2003 server in the event viewer/application I found many errors like this: "Error: 9001, Severity: 21, State: 1
The log for database 'ConsTest' is not available." The Source is "MSSQL"
Could anyone help me?
thanks in advance
bye
Luca

[Kristian Andersen]

It could be a hardware problem, so check that first, then try detaching and attaching the database, it will recreate the logfile.

http://technet.microsoft.com/en-us/library/ms190794.aspx

[Pieter 't Hart]

As you mention a clustered environment, you may have configured the resources incorrectly. Maybe the log-disk has failed over to another node ?

In a active/passive configuration, you should group the resources (disks, networkname/adress) needed for the database and configure all resources of this group to be served by the same clusternode.

Also configure dependencies so that the databaseinstance is not started before the disks and the network adress are online.

Pieter