How to shrink a database log file in SQL Server 2008
- May 22nd, 2010
- By Germán Medina
- Write comment
ALTER DATABASE database SET RECOVERY SIMPLE; dbcc shrinkfile (database_log, 1); ALTER DATABASE database SET RECOVERY FULL;
Archive for May, 2010
ALTER DATABASE database SET RECOVERY SIMPLE; dbcc shrinkfile (database_log, 1); ALTER DATABASE database SET RECOVERY FULL;