SQLServer清空日志

9/1/2015来源:SQL技巧人气:1703

SQLServer清空日志

 

USE [master]  GO  ALTER DATABASE TRAVEL SET RECOVERY SIMPLE WITH NO_WAIT  GO  ALTER DATABASE TRAVEL SET RECOVERY SIMPLE GO  USE TRAVEL GO  DBCC SHRINKFILE (N'TRAVEL_Log' , 11, TRUNCATEONLY)  GO  USE [master]  GO  ALTER DATABASE TRAVEL SET RECOVERY FULL WITH NO_WAIT  GO  ALTER DATABASE TRAVEL SET RECOVERY FULL GO