use [WSS_Content]
select * FROM sys.database_files
ALTER DATABASE [WSS_Content] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(WSS_Content_log, 1)
ALTER DATABASE [WSS_Content] SET RECOVERY FULL WITH NO_WAIT
use [WSS_Content]
ALTER DATABASE [WSS_Content] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(WSS_Content_log, 1)
ALTER DATABASE [WSS_Content] SET RECOVERY FULL WITH NO_WAIT
0 Responses to “Truncate log file in 2008 (no backup)”
Leave a Reply
You must login to post a comment.