1827757 Members
3160 Online
109969 Solutions
New Discussion

MSSQL2000

 
SV CENTRALI
Occasional Advisor

MSSQL2000

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
2 REPLIES 2
Kristian Andersen
Occasional Advisor

Re: MSSQL2000

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
Honored Contributor

Re: MSSQL2000

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