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’