we are using sql server 2000 and it's on a remote system. One of the databases "Dbase1" went to Suspect mode. when we checked both the .mdf and .ldf files were missing from the Server. they were not there at all. Is there any way to recover the databse. To make it more secure what are the possibilities which we can use so that in future we should be able to restore our databse.
Thanks in advance
Have you taken backup of the database "Dbase1"??? If so, you can restore it from the backup file. One more thing, when the database is attached to SQL, it is not possible to delete the physical files of the db as you will receive a error saying the files are in use. So check why the db files have been deleted.
thanks for your response. we have backup but that doesn't have latest SPs and tables. The files were on D: drive. Firstly it was showing around 2GB is free but all of a sudden it was showing 25Gb as free space and when we were running queries in Query Analyzer it was throwing error.
For developers to work we have attached the BackUp files with Sql Server.
Bab Anand wrote:
we have backup but that doesn't have latest SPs and tables.
If the files aren't there anymore, we can't magically make them reappear. We're good, but not that good
If you have any backup, that's probably better from starting over from scratch, which unfortunately seems to be your only other option.