It works, trust me. And when I say me, I mean Microsoft :).
SQL Server 2005:
BACKUP LOG MyDatabase WITH TRUNCATE_ONLY
DBCC SHRINKFILE(MyDatabase_log, 2000)
SQL Server 2008:
ALTER DATABASE MyDatabase SET RECOVERY SIMPLE
GO
DBCC Shrinkfile(MyDatabase_log, 2000)
No comments:
Post a Comment