Monday, March 26, 2012

Error 823: SQL service won't start!

Hello all,
Our database server went down due to a power outage but everything came back
fine except the MSSQL serverice won't start. I get the following error
listed below when trying to start the service. I tried starting the service
with the -f switch, which didn't work. I also tried the rebuildm.exe which
also failed. Would installing SQL to different drive be worth the effort?
Thank you for any advice!
Troy
spid5 Clearing tempdb database.
spid5 Encountered an unexpected error while checking the sector size for
file 'C:\Program Files\Microsoft SQL Server\MSSQL\DATA\TEMPDB.MDF'. Check
the SQL Server error log for more information.
spid5 CREATE DATABASE failed. Some file names listed could not be created.
Check previous errors.
spid5 Error: 823, Severity: 24, State: 6
spid5 I/O error 38(Reached the end of the file.) detected during read at
offset 0000000000000000 in file 'C:\Program Files\Microsoft SQL
Server\MSSQL\DATA\TEMPDB.MDF'.
spid5 WARNING: problem activating all tempdb files. See previous errors.
Restart server with -f to correct the situation.Your disk has a fatal error and you will not be able to start the server as
the disk is where it's trying to create the TEMPDB database, which is
required for the server to startup. You should contact PSS who will be able
to help you (http://support.microsoft.com)
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Travis" <Tkasch@.neb.rr.com> wrote in message
news:xzL%b.15820$QP.6929@.twister.rdc-kc.rr.com...
> Hello all,
> Our database server went down due to a power outage but everything came
back
> fine except the MSSQL serverice won't start. I get the following error
> listed below when trying to start the service. I tried starting the
service
> with the -f switch, which didn't work. I also tried the rebuildm.exe
which
> also failed. Would installing SQL to different drive be worth the effort?
> Thank you for any advice!
> Troy
> spid5 Clearing tempdb database.
> spid5 Encountered an unexpected error while checking the sector size for
> file 'C:\Program Files\Microsoft SQL Server\MSSQL\DATA\TEMPDB.MDF'. Check
> the SQL Server error log for more information.
> spid5 CREATE DATABASE failed. Some file names listed could not be created.
> Check previous errors.
> spid5 Error: 823, Severity: 24, State: 6
> spid5 I/O error 38(Reached the end of the file.) detected during read at
> offset 0000000000000000 in file 'C:\Program Files\Microsoft SQL
> Server\MSSQL\DATA\TEMPDB.MDF'.
> spid5 WARNING: problem activating all tempdb files. See previous errors.
> Restart server with -f to correct the situation.
>

No comments:

Post a Comment