Sorry, no can do, wish I could just restore from a backup. We're only talking 2 physical files files here, and they are both present.
>>> "the physical filename may be incorrect, could not restart database. Reverting back to old status".
>
>Sounds like one of the database files is missing. Can you restore from a backup?
>
>-Mike
>
>
>>I had a database that for some weired reason all of a suddden was marked suspect, so I reset the suspect flag, which worked but then it showed up as read only.
>>
>>Setting it to R/W produces error 5105 Device activation error and a long message saying that "the physical filename may be incorrect, could not restart database. Reverting back to old status".
>>
>>So I tried to do a backup only to be told that "The LSN (0:0:0) passed to log scan in database "DB Name" is invalid"
>>
>>So, what does one do?
>>
>>TIA
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)