Monday, March 12, 2012

HELP (!): Possible corrupted DB

Hello,
The problem accured with the database that contains critical data, so it is
very important to me to solve it as quickly as possible.
So the problem is that I cannot attach my database to the SQL server.
How all this began? At first I decided to back up my database. But by
mistake in stead of backuping I started restoring my database. After a few
seconds I realized that I was doing wrong operation, so I pressed STOP. The
restoring process seemed to be stopped, but unfortunately I couldn't do
anything with the database. Each time I tried I got an error "...restoring
is in progress..." or smth. Than I noticed that the status of the database
(in the enterprise manager) changed. The color of the database changed from
yellow to gray and the DB name became [database name] (loading). After t
hat
I decided to detach my database and re-attach it. Detaching completed
succesffuly, but now I cann't attach it. Each time when I try to attach I
got an error:
"Error 9004: An error occured while processing the log for database
'[database name]'".
(On the top of the message window: "Microsoft SQL-DMO (ODBC
SQLState:HY000)")
Attempts to attach database file without log ends with the same error.
What is wrong with my database? Is there any possibility to recover my
database? What actions should I take?
I appreciate any information.
By the way I use Enterprise manager for all operations.
Vycka
P.S. MS SQL Server 2000 (SP3), OS Win 2003Answered in .tools ... please stop multiposting.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Vycka" <Vyciunas@.One.Lt> wrote in message
news:ergHIXHNFHA.3708@.TK2MSFTNGP14.phx.gbl...
> Hello,
> The problem accured with the database that contains critical data, so it
is
> very important to me to solve it as quickly as possible.
> So the problem is that I cannot attach my database to the SQL server.
> How all this began? At first I decided to back up my database. But by
> mistake in stead of backuping I started restoring my database. After a few
> seconds I realized that I was doing wrong operation, so I pressed STOP.
The
> restoring process seemed to be stopped, but unfortunately I couldn't do
> anything with the database. Each time I tried I got an error "...restoring
> is in progress..." or smth. Than I noticed that the status of the database
> (in the enterprise manager) changed. The color of the database changed
from
> yellow to gray and the DB name became [database name] (loading). After
that
> I decided to detach my database and re-attach it. Detaching completed
> succesffuly, but now I cann't attach it. Each time when I try to attach I
> got an error:
> "Error 9004: An error occured while processing the log for database
> '[database name]'".
> (On the top of the message window: "Microsoft SQL-DMO (ODBC
> SQLState:HY000)")
> Attempts to attach database file without log ends with the same error.
> What is wrong with my database? Is there any possibility to recover my
> database? What actions should I take?
> I appreciate any information.
> By the way I use Enterprise manager for all operations.
> Vycka
> P.S. MS SQL Server 2000 (SP3), OS Win 2003
>

No comments:

Post a Comment