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
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment