sammydlc
asked on
SQL Express 2005 Database marked as Suspect
A few hours ago our office suffered a power failure that caused our SQL server to restart. After restoring the power, I came to see that my SQL database has marked my main application 's database as Suspect. I checked and both the .mdf files and on the drive. I also noticed that my last good backups were made back in Dec 2010. Is there a way to recover this db without doing a restore?
Last Comment
Daniel_PL
First of all please check SQL Server error logs, you'll find there indication what is wrong with the database (missing file, etc.) If you feel comfortable with that you can post log here for review.
>>Is there a way to recover this db without doing a restore?
the answer is simple NO you cannot recover a database with no restore.
the answer is simple NO you cannot recover a database with no restore.
You cannot restore datab without backup, but you can try to save as much data as you can in this kind of scenario.
So if you still need assistance with your suspect database just answer, I thought question was urgent ...
So if you still need assistance with your suspect database just answer, I thought question was urgent ...
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Yes, I wanted to suggest it to you. I guess you are aware of REPAIR_ALLOW_DATA_LOSS option. Glad you've got it working.
ASKER
It worked
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
