COMANDO BASE SUSPECT
— Passo 1
ALTER DATABASE HiperPdv SET EMERGENCY
ALTER DATABASE HiperPdv SET SINGLE_USER WITH ROLLBACK IMMEDIADTE
–Passo 2
DBCC checkDB (‘HiperPdv’, REPAIR)
–DBCC CheckDB(‘Hiperpdv’, REPAIR_ALLOW_DATA_LOSS)
–Passo 3
ALTER DATABASE HiperPdv SET MULTI_USER
ALTER DATABASE HiperPdv SET ONLINE
–passo 4
USE HiperPDV EXEC sp_msforeachtable ‘ALTER TABLE ? WITH CHECK CHEK CONSTRAINT All’