Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't set a DB to R/W
Message
From
31/01/2003 04:11:59
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Recovery
Title:
Can't set a DB to R/W
Miscellaneous
Thread ID:
00747566
Message ID:
00747566
Views:
49
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)
Next
Reply
Map
View

Click here to load this message in the networking platform