sorry - I don't understand the question. If you have no backups you can't recover the database. You need to check the SQL log to see if there is some clue as to why SQL is showing the database as suspect. Once you reoslve that and get the database back, start doing a proper backup routine!
SQL LOGs *Starting up database 'EMP_dedeman'. *SQL server listening on TCP, Shared Memory, Named Pipes. *SQL server listening on 10.34.10.73:1433, 127.0.0.1:1433. *SQL Server is ready for client connections *udopen: Operating system error 3(error not found) during the creation/opening of physical device D:\EMPDATA\EMP_Dedeman_Data.MDF. *FCB::Open failed: Could not open device D:\EPMDATA\EPM_Dedeman_Data.MDF for virtual device number (VDN) 1. *Device activation error. The physical file name 'D:\EPMDATA\EPM_Dedeman_Data.MDF' may be incorrect. *Device activation error. The physical file name 'D:\EPMDATA\EPM_Dedeman_Log.LDF' may be incorrect. *Clearing tempdb database.
So you have to check the physical file on the D drive. Does it exist - does the D drive have free space, is the file locked by any other process such as anti-virus software? Do the path and filenames point to actual files?
You don't know where you got the message saying that EPM_Dedeman was suspect? Do you have a problem at all - do you need this database? If so, when did the problem surface that it's data files are missing? You need to investigate your problem more fully.
DataBase Suspect
Forum Locked
Posted - 08/03/2004 : 08:31:41
