Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Updated text: 17 July 2006
Updated text: 14 April 2006
Truncating the log means that records of completed transactions that make up the inactive part of the log are deleted. The remaining incomplete transactions in the active part of the log are not deleted. The log is usually truncated after a backup.
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.
'Connect to the local, default instance of SQL Server. Dim srv As Server srv = New Server 'Reference the AdventureWorks database. Dim db As Database db = srv.Databases("AdventureWorks") 'Shrink the database without truncating the log. db.Shrink(20, ShrinkMethod.NoTruncate) 'Truncate the log. db.TruncateLog()