Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't set a DB to R/W
Message
De
31/01/2003 10:55:24
 
 
À
31/01/2003 09:48:12
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Recouvrement
Divers
Thread ID:
00747566
Message ID:
00747679
Vues:
16
SQL Server thinks that there's something wrong with one or both of the files. Which file is it complaining about? What do you get if you execute DBCC CHECKDB() and DBCC CHECKALLOC()?

Why can't you restore from a backup?

-Mike

>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
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform