如果ds_shop_log占用空间过大运行如下代码
运行SMSS 在ds_shop数据库新建查询语句
alter database ds_shop set emergency
use master
ALTER DATABASE ds_shop SET SINGLE_USER WITH ROLLBACK IMMEDIATE
dbcc checkdb(‘ds_shop’,REPAIR_ALLOW_DATA_LOSS)
dbcc checkdb(‘ds_shop’,REPAIR_REBUILD)
ALTER DATABASE ds_shop SET MULTI_USER WITH ROLLBACK IMMEDIATE
exec sp_resetstatus ‘ds_shop’
ALTER DATABASE ds_shop SET MULTI_USER WITH ROLLBACK IMMEDIATE
执行语句 等待
数据库右键→属性→选项→恢复模式改成简单
数据库右键→任务→收缩→文件→文件类型改成日志