数据库日志过大,执行简单几句语句即可缩小数据库日志

自助开通VIP,整站资源任意下载

Use QPAccountsDB
NAME,size From sys.database_files
ALTER DATABASE QPAccountsDB SET RECOVERY SIMPLE WITH NO_WAIT ALTER DATABASE QPAccountsDB SET RECOVERY SIMPLE USE QPAccountsDB
DBCC SHRINKFILE(N'QPAccountsDB_log',0,ONLY)
ALTER DATABASE QPAccountsDB SET RECOVERY FULL WITH NO_WAIT ALTER DATABASE QPAccountsDB SET RECOVERY FULL
GO
Use QPTreasureDB
NAME,size From sys.database_files
ALTER DATABASE QPTreasureDB SET RECOVERY SIMPLE WITH NO_WAIT ALTER DATABASE QPTreasureDB SET RECOVERY SIMPLE USE QPTreasureDB
DBCC SHRINKFILE(N'QPTreasureDB_log',0,ONLY)
ALTER DATABASE QPTreasureDB SET RECOVERY FULL WITH NO_WAIT ALTER DATABASE QPTreasureDB SET RECOVERY FULL

数据库日志过大,执行简单几句语句即可缩小数据库日志-第1张

本站源码仅做学术研究,自娱自乐使用,不得用于赌博性质的非法商业用途!转载请说明出处!
棋牌资源网 » 数据库日志过大,执行简单几句语句即可缩小数据库日志

这里有你所需要的,找专业的人做专业的事!

游戏演示 联系客服