2011年6月10日
SQL Server 2008 Resize LDF
摘要： USE dbname; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE dbname SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (2, 1); -- here 2 is the file ID for trasaction log file,you can also mention the log file name (dbname_log) . 阅读全文
posted @ 2011-06-10 00:00 胖胖安 阅读(190) 评论(0) 推荐(0)