1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
USE [master]  
GO  
ALTER DATABASE MobileStatLog SET RECOVERY SIMPLE WITH NO_WAIT  
GO 
ALTER DATABASE MobileStatLog SET RECOVERY SIMPLE   --simple model  
GO  
USE MobileStatLog
GO  
DBCC SHRINKFILE (N'MobileStatLog_Log' , 5, TRUNCATEONLY)  
GO  
USE [master]
GO  
ALTER DATABASE MobileStatLog SET RECOVERY FULL WITH NO_WAIT  
GO  
ALTER DATABASE MobileStatLog SET RECOVERY FULL  --restore for full model 
GO