database in load

Hello,

I am an administrator of a SQL server 2000 machine residing on a windows 2000 box. I tried restoring a database on this server from a backup file that i copied from another server. Halfway through the restore, the user comes up to me saying they did not want the database restored again. I stopped the restore process and since then it has not gone back to its previous state. Secondly it is grayed out with a (loading) text next to the database icon.

how did this happen and how do you suggest i solve this.

regards

This is because the restore process is not complete. Try dropping the database and restore the backup prior to this state as it will recreate the database.

Database Documentation is important

Hi
As a project manager,
=B7 Do you have an up-2-date overview of the database structure?
=B7 What will you do when your database administrator leaves your
company?
=B7 Are you willing to pay extra hours to update the database
information?
As a developer,
=B7 Do you spent too much hours on writing boring database
documentation?
=B7 Are you tired of not having the latest DB-information?
More info on www.dbmanual.com and download the free evaluation version.
FrederikI took a look at your live demo, and it seems to offer no advantages over
just browsing a database in Enterprise Manager. Explain the "documentation"
aspect of it.
<frederik@.dbmanual.com> wrote in message
news:1140473260.871832.218700@.g14g2000cwa.googlegroups.com...
Hi
As a project manager,
Do you have an up-2-date overview of the database structure?
What will you do when your database administrator leaves your
company?
Are you willing to pay extra hours to update the database
information?
As a developer,
Do you spent too much hours on writing boring database
documentation?
Are you tired of not having the latest DB-information?
More info on www.dbmanual.com and download the free evaluation version.
Frederik