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