Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 MSDE in "SUSPECT" mode.

Author  Topic 

cheng
Starting Member

1 Post

Posted - 2007-03-14 : 03:44:53
Hi experts,

I was trying to restore a "mdf" (MSDE) database for a HP OpenView product, unfortunately at the initial state of restoration, i got the following error messages:

Database 'openview' cannot be opened. It has been marked SUSPECT by recovery.
See the SQL Server errorlog for more information.


Any valuable suggestions on how to set/change the current "SUSPECT" mode so that the 'openview' database can be opened?

Many thanks,
Cheng

Kristen
Test

22859 Posts

Posted - 2007-03-14 : 04:45:56
"I was trying to restore a "mdf" ..."

How were you restoring the MDF file?

It sounds like you were not restoring from a Backup file?

Kristen
Go to Top of Page

SatyaSKJ
Starting Member

46 Posts

Posted - 2007-04-18 : 04:54:25
You can only attach a MDF file and as suggested you have to use RESTORE for database backup files only.

Satya SKJ
SQL Server MVP
http://www.sqlserver-qa.net
Go to Top of Page
   

- Advertisement -