suspect database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

suspect database

Author

Topic

shekhar_dba
Starting Member

39 Posts

Posted - 2007-04-24 : 15:42:43

Hi gurus

please help me in recovering suspect database.

thanks
shekhar

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-24 : 15:49:40

Did you try resetting the database? sp_resetstatus...

Post the errors from the Application Log and System Log in Event Viewer.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

shekhar_dba
Starting Member

39 Posts

Posted - 2007-04-24 : 16:42:44

Hi Tara
the following mentioned is the error from application log.theres no error in system log in regards with database.

17204
FCB::open failed: could not open device d:\cenmed.mdf for virtual device number(VDN)1.
thanks
shekhar

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-24 : 16:46:54

I'm going to ask the obvious...

Did you verify that d:\cenmed.mdf exists on the database server?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

shekhar_dba
Starting Member

39 Posts

Posted - 2007-04-24 : 16:49:25

Hi

No the file is not there on location.
thanks
shekhar

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-24 : 16:58:15

Well then that's the problem!

You need to find the file or restore from a backup.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

shekhar_dba
Starting Member

39 Posts

Posted - 2007-04-24 : 17:06:43

Hi

Actually i have restored this DB from one that is already on the server and that db is runing well.please elborate the steps to recover suspect db.

thanks
shekhar

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-24 : 17:15:12

I don't understand what you want from us. The MDF file didn't exist, so there is no way to recover the datase without a backup of some sort (whether it be a SQL backup or a tape backup of the file system).

Tara Kizer
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources