PHWinfo - Afficher un message

31/03/2008, 14h58

Dumb: I posted this in another group a week ago, then wondered why I got no
reply. Turns out that group doesn't exist anymore--at least on msnews,
other newsservers stil carry it, but the activity level is near-zero

-----

I'm trying to recover as much as possible from a database that has become
the victim of data corruption on disk.

The database uses simple recovery model. There are daily full backups,
archived to 7 days back, but the problem was detected too late, so the
errors also exist in all available backups.

I restored the latest backup on another machine, set it to single user, and
tried to run DBCC CHECKDB with the REPAIR_FAST option.

This results in an error message:

Msg 5244, Level 16, State 1, Server WS-LUC-2, Line 1
Repair statement not processed. One or more files in the database are
read-only and must be made writeable in order to run repair.

None of the database files is read-only though, there must be another
reason why writing fails.

Has anyone ever encountered this?

PS: the database was created on SQL Server 2005 Express Edition, I've tried
the repair on 2005 EE as well as on a full 2005 server. The result remains
the same.

31/03/2008, 14h58	#1
Luc Messages: n/a Hébergeur:	DBCC CHECKDB REPAIR error 5244 Dumb: I posted this in another group a week ago, then wondered why I got no reply. Turns out that group doesn't exist anymore--at least on msnews, other newsservers stil carry it, but the activity level is near-zero ----- I'm trying to recover as much as possible from a database that has become the victim of data corruption on disk. The database uses simple recovery model. There are daily full backups, archived to 7 days back, but the problem was detected too late, so the errors also exist in all available backups. I restored the latest backup on another machine, set it to single user, and tried to run DBCC CHECKDB with the REPAIR_FAST option. This results in an error message: Msg 5244, Level 16, State 1, Server WS-LUC-2, Line 1 Repair statement not processed. One or more files in the database are read-only and must be made writeable in order to run repair. None of the database files is read-only though, there must be another reason why writing fails. Has anyone ever encountered this? PS: the database was created on SQL Server 2005 Express Edition, I've tried the repair on 2005 EE as well as on a full 2005 server. The result remains the same.