MS SQL Server - loading status after restore database

Author

loading status after restore database

Iter

2006-12-06, 7:12 pm

Hi Guys,
I got a trouble after I restored my database. I forgot disconnecting all
connection when I restored my database. I continued to restore my database
after I disconnected all connection, then it was successfully restored. But I
found the database was marked as loading and database was as unsuspected mode
and icon became grey. How can I recover my database? Thanks.

Hate_orphaned_users

2006-12-06, 7:12 pm

Could be that the database got corrupt.
Try to Delete the database and do the restore again, or force a restore over
the suspect database.
Alternative , detach the suspect db and the do a restore.

Good luck.

"Iter" wrote:

> Hi Guys,
> I got a trouble after I restored my database. I forgot disconnecting all
> connection when I restored my database. I continued to restore my database
> after I disconnected all connection, then it was successfully restored. But I
> found the database was marked as loading and database was as unsuspected mode
> and icon became grey. How can I recover my database? Thanks.
>

Tibor Karaszi

2006-12-06, 7:12 pm

You forgot to specify RECOVERY. This is easy to handle:

RESTORE DATABASE dbname WITH RECOVERY

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

"Iter" <Iter@discussions.microsoft.com> wrote in message
news:3A85C852-2A74-45DC-8F78- 9B8B2C81A3B9@microso
ft.com...
> Hi Guys,
> I got a trouble after I restored my database. I forgot disconnecting all
> connection when I restored my database. I continued to restore my database
> after I disconnected all connection, then it was successfully restored. But I
> found the database was marked as loading and database was as unsuspected mode
> and icon became grey. How can I recover my database? Thanks.
>

Sponsored Links