"Brad Pears" <br***@truenorthloghomes.com> wrote in message
news:OTXUGaOXHHA.388@TK2MSFTNGP04.phx.gbl...
> Last night we had a major storm hit us and the power went out. The SQL 2000 server has a UPS on it
> so should have went down gracefully - but who knows. Anyway, this morning no one was able to get
> into the data. When I checked the server, I noticed that all of our databases (except the test
> databases installed by default when you install SQL Server) were marked as 'suspect'. Drilling
> down in th4e database yields no tables or anything. It jsut says no items present.
>
> I am new to SQL server and have never seen this before. The server has been rebooted - it did not
> help. All services are running just fine. I checked the event viewer and do not see anything wrong
> there. Is there a specific SQL server log somewhere ??
>
> Help!!  What do I do to get these databases back up?? All my users are chompoing at the bit!!!
>
> Thanks,  Brad
>

"Tibor Karaszi" wrote:

> There's a possibility that it is restore time, so you might as well initiate the process to find
> your backups.
>
> SQL Servers error log file is in the folder for your instance\log. for instance, on my machine, with
> a named 2000 instance:
> C:\Program Files\Microsoft SQL Server\MSSQL$SS2000I1\LOG
>
> Here are my general recommendations for suspect and corrupt databases:
> http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "Brad Pears" <br***@truenorthloghomes.com> wrote in message
> news:OTXUGaOXHHA.388@TK2MSFTNGP04.phx.gbl...
> > Last night we had a major storm hit us and the power went out. The SQL 2000 server has a UPS on it
> > so should have went down gracefully - but who knows. Anyway, this morning no one was able to get
> > into the data. When I checked the server, I noticed that all of our databases (except the test
> > databases installed by default when you install SQL Server) were marked as 'suspect'. Drilling
> > down in th4e database yields no tables or anything. It jsut says no items present.
> >
> > I am new to SQL server and have never seen this before. The server has been rebooted - it did not
> > help. All services are running just fine. I checked the event viewer and do not see anything wrong
> > there. Is there a specific SQL server log somewhere ??
> >
> > Help!!  What do I do to get these databases back up?? All my users are chompoing at the bit!!!
> >
> > Thanks,  Brad
> >
>
>