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
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