Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
SQL Server failureHi 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.
Post Follow-up to this message
Re: SQL Server failureThis 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.
Post Follow-up to this message Re: SQL Server failureTom 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. > > >
Post Follow-up to this message Re: SQL Server failureTalk 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. > > >
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
