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 trackbacks yet.
How to use SSL in a WCF service
How to install Linux Integration Services Version 2.1 on a Hyper-V virtual machine running Debian
No comments yet.