USE [master]  

GO  

ALTER DATABASE [数据库名] SET RECOVERY SIMPLE WITH NO_WAIT  

GO  

ALTER DATABASE [数据库名] SET RECOVERY SIMPLE  

GO  

USE [数据库名]  

GO  

DBCC SHRINKFILE (N'[数据库日志文件名称]' , 0,TRUNCATEONLY)  

GO  

USE [master]  

GO  

ALTER DATABASE [数据库名] SET RECOVERY FULL WITH NO_WAIT  

GO  

ALTER DATABASE [数据库名] SET RECOVERY FULL  

GO  

 

--查询指定数据库的日志文件名称  

USE [数据库名]   

GO  

SELECT name FROM SYS.database_files WHERE type_desc='LOG' 


Copyright © 2014-2017 it689.com (京ICP备12032795号-2) 版权所有 Power by IT689