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 ?Could you post the error messages from the SQL Server error log? It can be
located in the MSSQL\Log folder in your installation directory
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:uTrUGnHiGHA.1276@.TK2MSFTNGP03.phx.gbl...
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 ?|||Whell Narayana
After i detach the database and tried to reattach i got the error: 823 error
id (Bad page Id)
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:u$%239wmKiGHA.4892@.TK2MSFTNGP02.phx.gbl...
> Could you post the error messages from the SQL Server error log? It can be
> located in the MSSQL\Log folder in your installation directory
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:uTrUGnHiGHA.1276@.TK2MSFTNGP03.phx.gbl...
> 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