How do I delete suspect database?

How do I completely delete a database?

To delete a database Expand Databases, right-click the database to delete, and then click Delete. Confirm the correct database is selected, and then click OK.

How do I delete a pending recovery database?

Frequently Asked Questions1Stop SSMS Service.2Navigate to the location where your MDF and LDF files are located.3Delete both and restart the SQL Server services.4Open SSMS and expand the database folder. You can also see that the database is in a pending state.5Right click on the database and delete it.How to Remove Recovery Pending state in SQL Server - Query Resolved

What causes suspect database?

Following are some of the reasons behind a Suspect database: The device or drive is inaccessible to the server where the server log files are kept. This can be caused by corruption in the hard drive sector or partition. The files are missing and cannot be found. There can be many causes for Suspect database.

What is the command to delete a database?

To do delete a database you need the command 'DROP DATABASE'. The syntax is similar to creating a database. 'DROP DATABASE <name>;', where <name> is the name of the database you want to delete.