I have a database marked as suspect in MS/SQL.
The reason is simple : the data files are not there anymore.
In fact I had to restart MS/SQL after copying back all the ldf and mdf files that were savec when MS/SQL was down, but one extremely large database used for test I didn't copy back as I don't need it anymore (I need it empty but with no data).
But now MS/SQL of course says it is market as suspect which is normal.
How can I definitively drop it then create it back from scratch ?
I do not want (too long) to copy back the corresponding ldf and mdf files which of course is one solution, but too long for me.