Database files are "Hidden" after becoming Suspect

From: rgn (gopinathr_at_healthasyst.com)
Date: 02/14/05 

Date: Mon, 14 Feb 2005 17:23:35 +0530

We had created some databases on the C Drive. Today the C drive went bad and
all the databases that
were on the C Drive became suspect.

I tried to copy the files onto another drive and I did to the D drive.
However, when I tried to attach the
datafile the data file was not showing up. I checked the properties and the
file's "Read Only" attribute was checked.
I unchecked it. However, the "Hidden" attribute has been greyed out and
looks like this is the reason why
the files are not showing up.

Would someone know how to address this problem ?

Thanks,
rgn

Relevant Pages

  • Re: Database files are "Hidden" after becoming Suspect
    ... Mike Epprecht, Microsoft SQL Server MVP ... > We had created some databases on the C Drive. ... > datafile the data file was not showing up. ...
    (microsoft.public.sqlserver.server)
  • Newbie Help!
    ... we are using Sharepoint POrtal server with a SQL ... and I notice the LDF is showing 0kb size. ... The msdb.mdf is also showing as suspect. ... The MDF's are on a RAID array with 270GB free space so the databases did not ...
    (microsoft.public.sqlserver.server)
  • Re: Suspect Databases and Hidden Attributes
    ... but also the OS was interpreting them as "Operating System Protected OS ... I was able to attach the data file using sp_attach_db but not using ... >> a reboot of the machine, the files of databases that were in Suspect mode ... >> I tried to attach the datafile the data file was not showing up. ...
    (microsoft.public.sqlserver.programming)
  • RE: Suspect Databases and Hidden Attributes
    ... > a reboot of the machine, the files of databases that were in Suspect mode ... > the same file in other location while I was trying to restore the databases. ... > those copies of these data files disappeared. ... > I tried to attach the datafile the data file was not showing up. ...
    (microsoft.public.sqlserver.programming)
  • still getting log ship alerts
    ... the "Log Shipping alert job-restore" job keeps showing a status of "failed", ... however the databases are in sync. ... I do have sp3; I sent this message ...
    (microsoft.public.sqlserver.server)