troubleshooting Question

Drop Failed: Access to Table dbo.suspect_pages is blacked

Avatar of gtrapp
gtrapp asked on
MySQL Server
1 Comment1 Solution969 ViewsLast Modified:
Hi,

I am trying to drop a database, but seeing an error and can't drop the database. This is an old unused WSS 3.0 database, and I have SQL Server 2005 on the server. I tried dropping the database within Mangement Studio.

Drop Failed For Database "WSS_Content_81"

Access to table dbo.suspect_pages is blocked because the signature is not valid. Problems recording information in the msdb..suspect_pages table were encountered. This error does not interfere with any activity expect maintenance of the suspect_pages table. Check the error log for more information. Microsoft SQL Server, Eorror: 33002)

I also tried the drop command, but received a:

Cannot drop the database 'wss_content_81', because it does not exist or you do not have permission.

Now a restart of the server, MS SQL and SharePoint services may resolve this problem and the database will be gone. However, can you suggest other solutions?

Thanks.
ASKER CERTIFIED SOLUTION
dkempton

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 1 Comment.
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 1 Comment.
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