DAtabase Recovery from emergency mode

We had a RAID breakdown that brought around 20 of our
databases each around 100 GB in Emergency mode.
What is the best way to recover the database.
We have tried the method of renaming the database files
and log files and running the following set of commands:-
sp_configure 'allow updates', 1
go
reconfigure with override
go
use master
go
Update sysdatabases set status = 32768 where name = 'TEST'
go
sp_configure 'allow updates', 0
go
reconfigure with override
But when we try to re gendrate the logs it fails with the
DBNETLIB error.
How shoule we procede to recover the databasesrecreate the RAID and attach the databases. There is also a way to reset the database state in the configuration table.
rgn|||The best way is from good backups. If your Raid crashed that hard you can
not be sure of the integrity of the files and restoring from backups is the
proper way to recover them.
--
Andrew J. Kelly
SQL Server MVP
"YOGI.GUPTA@.MAIL.SPRINT.COM" <anonymous@.discussions.microsoft.com> wrote in
message news:019001c3ca6e$92327720$a401280a@.phx.gbl...
> We had a RAID breakdown that brought around 20 of our
> databases each around 100 GB in Emergency mode.
> What is the best way to recover the database.
> We have tried the method of renaming the database files
> and log files and running the following set of commands:-
> sp_configure 'allow updates', 1
> go
> reconfigure with override
> go
> use master
> go
> Update sysdatabases set status = 32768 where name = 'TEST'
> go
> sp_configure 'allow updates', 0
> go
> reconfigure with override
> But when we try to re gendrate the logs it fails with the
> DBNETLIB error.
> How shoule we procede to recover the databases
>