sqlserver只剩下mdf文件附加办法——亲测有效

其中DBNAME是你数据库的名字，替换即可
ALTER DATABASE [DBNAME] SET EMERGENCY
DBCC checkdb([DBNAME])
ALTER DATABASE [DBNAME] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ([DBNAME], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [DBNAME] SET MULTI_USER