By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,612 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

SQL Server 2000 Cannot Restore

P: n/a
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

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

<ds***********@planetmagpie.com> wrote in message
news:11**********************@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

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.