Management Studio for that. If you have it, you need to follow the steps given below:
Open Microsoft SQL Server Management Studio on your system.
Now click on New Query button.
A new query page will be opened. Write the SQL scripts (shown below) on the page:
EXEC sp_resetstatus [YourDatabase];
ALTER DATABASE [YourDatabase] SET EMERGENCY
DBCC checkdb ([YourDatabase])
ALTER DATABASE [YourDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC DATABASE ([YourDatabase], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [YourDatabase] SET MULTI_USER
Now click on Execute.
Now you can see the file is not tagged as Suspect.
Some useful links from Internet space:
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/1462-sql-server-2005-database-lost - great solutions and a lot of users who can share their knowledge about sql databases
https://sql.recoverytoolbox.com/ Recovery Toolbox for SQL Server - in case any solution cant assist you, you make use of this tool