Re: Suspect Databases and Hidden Attributes
From: rgn (gopinathr_at_healthasyst.com)
Date: 02/15/05
- Next message: Vinod Kumar: "Re: A lot of sp_cursorfetch in profiler."
- Previous message: Tibor Karaszi: "Re: A lot of sp_cursorfetch in profiler."
- In reply to: John Bell: "RE: Suspect Databases and Hidden Attributes"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Feb 2005 16:02:26 +0530
Hello John,
Actually, we found out this morning that the files not only had the "Hidden"
Attribute turned on
but also the OS was interpreting them as "Operating System Protected OS
file" and the reason why these files
seemed disappeared.
We unchecked the "Hide Protected Operating System File" option from the
Tools--> Folder Options
and we were able to see the files.
Finally, I was able to attach the data file using sp_attach_db but not using
sp_attach_single_file_db.
Thanks,
Gopi
"John Bell" <JohnBell@discussions.microsoft.com> wrote in message
news:E958C72E-EB54-4F54-942B-9C16E992FCA0@microsoft.com...
> Hi
>
> It is not totally clear from your post what the actual sequence of events
> were. I don't think that just coping files should not change the file
> attributes. If you were copying from a CD/DVD then the files would be read
> only.
>
> Without properly detaching the database or shutting down SQL Server
> cleanly,
> your database would have been in a inconsistent state and thererefore the
> database would be put into recovery mode when restarted. It might be that
> this process had finished before you tried your second re-start.
>
> John
>
>
>
> "gopi" wrote:
>
>> Hello All,
>>
>> I had posted this in the SQLServer.Server group as well. I just want to
>> add
>> that after
>> a reboot of the machine, the files of databases that were in Suspect mode
>> disappeared. I had copied
>> the same file in other location while I was trying to restore the
>> databases.
>> However, even
>> those copies of these data files disappeared.
>>
>> Gopi
>>
>> 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
>>
>>
>>
>>
- Next message: Vinod Kumar: "Re: A lot of sp_cursorfetch in profiler."
- Previous message: Tibor Karaszi: "Re: A lot of sp_cursorfetch in profiler."
- In reply to: John Bell: "RE: Suspect Databases and Hidden Attributes"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
