• to recover data from suspected database do the following

    1. open master database

    2. open table sysdatabases

    3. change the 'status' value of ur database to 32768

    4. refresh the sql server

    5. now the suspect mode changed to emergency mode

    6. create a new database using same script of curepted database

    7. using import data facility transfer all data to new db

    8. detach the currupted db and attach new db