|
|
"Vycka" <Vyciunas@One.Lt> wrote in message
news:umJC8XHNFHA.1172@TK2MSFTNGP12.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
>
>
try this one
sp_attach_single_fil
e_db
look it up in sql books online - it will create a new log file whilst
attaching
best regards
lefty
|
|