Hello All,

I am not a SQL Server expert, but I have been put in a pretty
precarious situtation and I am close to panicking I have need to
restore a SQL database from backup (through Enterprise Manager). The
database got corrupt and I detached it, then was unable to attach it
again. I created a new database with the same name and file names to
restore to. When I go to All Tasks, restore, and restore from a
previously run full backup, it says "SQL Server is currently in the
process of restoring the backup set," but the progress bar does not
budge. I look in the data folder and see the full sized transaction
logs (35GB I know, need to be shrunk). The .mdf file remains at 1024K
though. Do I need to just wait longer? Normally when restoring from a
SQL Server .BAK file, the progress is shown to me as it goes along. I
do not know what to do here. Any help would be GREATLY appreciated. I
apologize for sounding like a newbie, but with SQL Server, I am
definitely in that category.

Thanks,
-D

<dschneiderman@planetmagpie.com> wrote in message
news:1103600714.825688.242920@f14g2000cwb.googlegr oups.com...
> Hello All,
>
> I am not a SQL Server expert, but I have been put in a pretty
> precarious situtation and I am close to panicking I have need to
> restore a SQL database from backup (through Enterprise Manager). The
> database got corrupt and I detached it, then was unable to attach it
> again. I created a new database with the same name and file names to
> restore to. When I go to All Tasks, restore, and restore from a
> previously run full backup, it says "SQL Server is currently in the
> process of restoring the backup set," but the progress bar does not
> budge. I look in the data folder and see the full sized transaction
> logs (35GB I know, need to be shrunk). The .mdf file remains at 1024K
> though. Do I need to just wait longer? Normally when restoring from a
> SQL Server .BAK file, the progress is shown to me as it goes along. I
> do not know what to do here. Any help would be GREATLY appreciated. I
> apologize for sounding like a newbie, but with SQL Server, I am
> definitely in that category.

First advice, forget Enterprise Manager.

Use Query analyzer.
RESTORE DATABSE FOO from disk='e:\foo.bak' with stats
(adapt syntax as required.)


In any case:
1) you don't need to create a new database.
2) If the transaction log is 35Gig, SQL Server will instruct the OS to
allocate 35 gig of disk space and then it does some checking on that space.
So, it could easily take an hour or more (depending on the speed of your
disks, etc.) to do that. During that time it'll appear that there's nothing
happening. You'll see no progress bar change, and if you do it via QA, the
stats won't change at all.

If you need more help, I'm sure come morning others will be logged in and
can help then.


>
> Thanks,
> -D
>