PLS HELP: Database is marked as (loading) after restore

Hi,
We just restored a database to SQL Server 2000 and now if i go to
Enterprise Manager i see that database with "(loading)" on the right.
When i click on expnand sign, i see "No Items"?
When i try to see it's properties i get this message:
"Error 927: Database "DBName" can not be opened. It is in the middle of
a restore."
But how come - i've seen the restore finished successfully.
Any ideas?
Thank you,
MuZZyTry:
restore database MyDB with recovery
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"MuZZy" <tnr@.newsgroups.nospam> wrote in message
news:uzB73n8DGHA.3528@.TK2MSFTNGP12.phx.gbl...
Hi,
We just restored a database to SQL Server 2000 and now if i go to
Enterprise Manager i see that database with "(loading)" on the right.
When i click on expnand sign, i see "No Items"?
When i try to see it's properties i get this message:
"Error 927: Database "DBName" can not be opened. It is in the middle of
a restore."
But how come - i've seen the restore finished successfully.
Any ideas?
Thank you,
MuZZy|||Hi MuZZy
What do you mean that you have 'seen the restore finished successfully'?
Does that mean you were able to use the database after the restore?
It's possible you ran the restore with NORECOVERY.
Try using Query Analyzer and recovering the database:
RESTORE DATABASE DBName WITH RECOVERY
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"MuZZy" <tnr@.newsgroups.nospam> wrote in message
news:uzB73n8DGHA.3528@.TK2MSFTNGP12.phx.gbl...
> Hi,
> We just restored a database to SQL Server 2000 and now if i go to
> Enterprise Manager i see that database with "(loading)" on the right. When
> i click on expnand sign, i see "No Items"?
> When i try to see it's properties i get this message:
> "Error 927: Database "DBName" can not be opened. It is in the middle of a
> restore."
> But how come - i've seen the restore finished successfully.
> Any ideas?
> Thank you,
> MuZZy
>|||MuZZy wrote:
> Hi,
> We just restored a database to SQL Server 2000 and now if i go to
> Enterprise Manager i see that database with "(loading)" on the right.
> When i click on expnand sign, i see "No Items"?
> When i try to see it's properties i get this message:
> "Error 927: Database "DBName" can not be opened. It is in the middle of
> a restore."
> But how come - i've seen the restore finished successfully.
> Any ideas?
> Thank you,
> MuZZy
Thanks for your responses, guys. I tried that but got an error saying that database file is restored
only partially so command acn't be completed or something like that.
It seems to me that the backup file is somehow invalid, as we never had any problems with another
clients' backups ever. I'm going to ask them to send me another backup ad we'll see then|||Perhaps you were sent a backup which didn't contain all the filesgroups for the database. That can
be on possible reason.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"MuZZy" <tnr@.newsgroups.nospam> wrote in message news:OJMT2V%23DGHA.2424@.TK2MSFTNGP10.phx.gbl...
> MuZZy wrote:
>> Hi,
>> We just restored a database to SQL Server 2000 and now if i go to Enterprise Manager i see that
>> database with "(loading)" on the right. When i click on expnand sign, i see "No Items"?
>> When i try to see it's properties i get this message:
>> "Error 927: Database "DBName" can not be opened. It is in the middle of a restore."
>> But how come - i've seen the restore finished successfully.
>> Any ideas?
>> Thank you,
>> MuZZy
> Thanks for your responses, guys. I tried that but got an error saying that database file is
> restored only partially so command acn't be completed or something like that.
> It seems to me that the backup file is somehow invalid, as we never had any problems with another
> clients' backups ever. I'm going to ask them to send me another backup ad we'll see then|||Hi Muzzy,
First of all, as MVP Tibor suggested, please make sure you have contained
all the filegroups for the database.
Secondly, if the database file located remotely, please copy them to local
and then try to resotre again.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.