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, 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 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" <bradp@.truenorthloghomes.com> wrote in message
> news:OTXUGaOXHHA.388@.TK2MSFTNGP04.phx.gbl...
>