troubleshooting Question

Databases in Suspect Mode

Avatar of Bodhi108
Bodhi108 asked on
Microsoft SQL ServerMicrosoft SQL Server 2008SSRS
4 Comments1 Solution737 ViewsLast Modified:
Today, someone added space to one of our disks where our log files reside.  The drive was backed up without the databases being stopped!  Before restoring the drive, the database was stopped.  Luckily, no new data to the database had been added since we did the backup.

When we brought up the databases, they all became suspect.  Luckily, I had a backup of two of the databases but the other two, the ReportServer and ReportServerTempTempDB, we have never done a backups!!!

I believe the reason it is suspect is because our log files are out of sync.  Our .mdf should be fine but the .ldf is not.  Is there a way I can bring the database out of suspect?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros