Monday 30 May 2011

suspect mode recovery

exec sp_resetstatus 'rate'

dbcc dbrecover (rate)

sp_configure "allow updates", 1
go
reconfigure with override
go

update sysdatabases
set status = 4112
where name = 'reservation'

dbcc checkdb (rate)

alter database rate
set single_user
dbcc checkdb (rate, repair_allow_data_loss)
sp_helpdb rate

select status from sysdatabases where name = 'rate'

dbcc dbrecover (reservation)

atabase reserva

dbcc checkdb (rate, repair_allow_data_loss)
sp_who


sp_configure

No comments:

Post a Comment