• oh, i'm so sorry...forgot to ans it. i have old backup before hard disk failure. i just get mdf & ldf file only after retrieving. i try to set emergency mode but certain table can view correctly & some table show;

    "I/O error (bad page ID) detected during read at offset 0x000000f9a70000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\PMSdb.mdf'."

    after viewing. so how to repair it using SQL command?