Help! Databases marked as suspect..

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, BradThere'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 insta
nce, 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/in..._suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Brad Pears" <bradp@.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 200
0 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 databa
ses (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 bee
n rebooted - it did not
> help. All services are running just fine. I checked the event viewer and d
o 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 cho
mpoing at the bit!!!
> Thanks, Brad
>|||Definately read Tibor's link and pay attention to the part about backing up
the log with no_truncate to get everything you can get restored.
DatabaseAdmins.com
Remote DBA services
"Tibor Karaszi" wrote:

> There's a possibility that it is restore time, so you might as well initia
te the process to find
> your backups.
> SQL Servers error log file is in the folder for your instance\log. for ins
tance, 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/in..._suspect_db.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Brad Pears" <bradp@.truenorthloghomes.com> wrote in message
> news:OTXUGaOXHHA.388@.TK2MSFTNGP04.phx.gbl...
>