Friday, February 17, 2012

Database damage

Hello there
I tried to run simple query on one of my database.
Afrer 5 hours of work i tried to stop it and the sql didn't let me to stop.
Therefore i had do shut down the server and run it again.
When i run it again the server has come up and the database become gray with
(suspect).
The database cannot be used any more, and on the log file it seems that it
could not be recovered.
What i need to do now to recover the database ?Which version of SQL Server are you using?
Are there any error messages from the SQL Server error log?
Do you have a backup of the database?
Martin C K Poon
Senior Analyst Programmer
====================================
"Roy Goldhammer" <roy@.hotmail.com> bl
news:OMOcPVHiGHA.4044@.TK2MSFTNGP03.phx.gbl g...
> Hello there
> I tried to run simple query on one of my database.
> Afrer 5 hours of work i tried to stop it and the sql didn't let me to
stop.
> Therefore i had do shut down the server and run it again.
> When i run it again the server has come up and the database become gray
with
> (suspect).
> The database cannot be used any more, and on the log file it seems that it
> could not be recovered.
> What i need to do now to recover the database ?
>

No comments:

Post a Comment