USE KMx10
GO
ALTER DATABASE KMx10 SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
DBCC CHECKTABLE (N'job',REPAIR_REBUILD) WITH NO_INFOMSGS, ALL_ERRORMSGS;
GO
ALTER DATABASE KMx10 SET MULTI_USER;
USE KMx10
GO
ALTER DATABASE KMx10 SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
DBCC CHECKTABLE (N'job',REPAIR_REBUILD) WITH NO_INFOMSGS, ALL_ERRORMSGS;
GO
ALTER DATABASE KMx10 SET MULTI_USER;
RESTORE DATABASE YourDatabaseName WITH RECOVERY;