|
Home > Archive > MS SQL Server > August 2005 > SQL Server failure
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server failure
|
|
| bjones 2005-08-30, 7:23 am |
| Hi
We have a SQL Server 7.00 - 7.00.961 on a micorosft cluster environment
which failed over the weekend with following errors.
LogWriter: Operating system error 2(error not found) encountered.
Write error during log flush. Shutting down server
Error: 9001, Severity: 21, State: 4
The log for database 'distribution' is not available..
Error: 823, Severity: 24, State: 10
I/O error 2(error not found) detected during read of page buffer..
FetchLSNBackward: Operating system error 997(error not found) encountered.
| |
| Tom Moreau 2005-08-30, 7:23 am |
| This smells like a disk failure. Can you run some hardware diagnostics to
locate the problem?
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"bjones" <bjones@discussions.microsoft.com> wrote in message
news:CCA58581-3220-489A-9663- 1B719C9084BD@microso
ft.com...
Hi
We have a SQL Server 7.00 - 7.00.961 on a micorosft cluster environment
which failed over the weekend with following errors.
LogWriter: Operating system error 2(error not found) encountered.
Write error during log flush. Shutting down server
Error: 9001, Severity: 21, State: 4
The log for database 'distribution' is not available..
Error: 823, Severity: 24, State: 10
I/O error 2(error not found) detected during read of page buffer..
FetchLSNBackward: Operating system error 997(error not found) encountered.
| |
| bjones 2005-08-30, 7:23 am |
| Tom
The cluster on restart came up with no errors on SQL Server and no
corruptions on databases. There is nothing written to the eventlogs on the
servers. What additional diagnostics can be run to locate the problem?
Thanks
"Tom Moreau" wrote:
> This smells like a disk failure. Can you run some hardware diagnostics to
> locate the problem?
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "bjones" <bjones@discussions.microsoft.com> wrote in message
> news:CCA58581-3220-489A-9663- 1B719C9084BD@microso
ft.com...
> Hi
>
> We have a SQL Server 7.00 - 7.00.961 on a micorosft cluster environment
> which failed over the weekend with following errors.
>
> LogWriter: Operating system error 2(error not found) encountered.
> Write error during log flush. Shutting down server
> Error: 9001, Severity: 21, State: 4
> The log for database 'distribution' is not available..
>
> Error: 823, Severity: 24, State: 10
> I/O error 2(error not found) detected during read of page buffer..
> FetchLSNBackward: Operating system error 997(error not found) encountered.
>
>
>
| |
| Tom Moreau 2005-08-31, 7:23 am |
| Talk you your hardware vendor re diagnostics. As for SQL Server, go with
DBCC CHECKDB, DBCC CHECKALLOC and DBCC CHECKCATALOG.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"bjones" <bjones@discussions.microsoft.com> wrote in message
news:2ABBE7BA-D8A3-49D3-89BE- 7C460AA140A5@microso
ft.com...
Tom
The cluster on restart came up with no errors on SQL Server and no
corruptions on databases. There is nothing written to the eventlogs on the
servers. What additional diagnostics can be run to locate the problem?
Thanks
"Tom Moreau" wrote:
> This smells like a disk failure. Can you run some hardware diagnostics to
> locate the problem?
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "bjones" <bjones@discussions.microsoft.com> wrote in message
> news:CCA58581-3220-489A-9663- 1B719C9084BD@microso
ft.com...
> Hi
>
> We have a SQL Server 7.00 - 7.00.961 on a micorosft cluster environment
> which failed over the weekend with following errors.
>
> LogWriter: Operating system error 2(error not found) encountered.
> Write error during log flush. Shutting down server
> Error: 9001, Severity: 21, State: 4
> The log for database 'distribution' is not available..
>
> Error: 823, Severity: 24, State: 10
> I/O error 2(error not found) detected during read of page buffer..
> FetchLSNBackward: Operating system error 997(error not found) encountered.
>
>
>
|
|
|
|
|