August 2010
M T W T F S S
« Dec   Oct »
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Archive for August 23rd, 2010

23
Aug

Truncate log file in 2008 (no backup)

 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