Shrink лог файлов в MSSQL 2008 и MSSQL 2008R2
USE [database name] ALTER DATABASE [database name] SET RECOVERY SIMPLE DBCC SHRINKFILE([log file name], <preferred size>) ALTER DATABASE [database name] SET RECOVERY FULL
USE [database name] ALTER DATABASE [database name] SET RECOVERY SIMPLE DBCC SHRINKFILE([log file name], <preferred size>) ALTER DATABASE [database name] SET RECOVERY FULL
select substring(o.name, 1, 30) Table_Name ,i.rows Number_of_Rows from sysobjects o inner join sysindexes i on (o.id = i.id) where o.xtype = ‘u’ and i.indid < 2 order by o.name