删除数据库日志

USE [dbName];
ALTER DATABASE [dbName] SET RECOVERY SIMPLE;
ALTER DATABASE [dbName] SET RECOVERY FULL;
DBCC SHRINKDATABASE([dbName],0)

posted @ 2014-08-18 15:52  apegu  阅读(167)  评论(0编辑  收藏  举报