Shrinking SQL Server Transaction Logs with SQL-DMO

Armen Hakobyan

Rate me:

4.99/5 (49 votes)

21 Apr 2004CPOL9 min read

204.1K

4.7K

Using SQL-DMO to shrink SQL Server transaction logs.

tlsw_proj.zip
- tlsw
  - bin
    - RCStamp.txt
  - setup
    - eula.txt
    - tlswa.inf
    - tlswa.txt
  - tlsw.dsw
  - tlsw.sln
  - tlsw.sln.2003
  - tlswa
    - aboutdlg.cpp
    - aboutdlg.h
    - controls.h
    - dmosink.cpp
    - dmosink.h
    - main.cpp
    - main.h
    - res
      - Backup.ico
      - tlswa.exe.manifest
      - tlswa.ico
      - WizHdr.bmp
      - WizMark.bmp
    - resource.h
    - stdafx.cpp
    - stdafx.h
    - tlswa.dsp
    - tlswa.rc
    - tlswa.vcproj
    - tlswa.vcproj.2003
    - verinfo.cpp
    - verinfo.h
    - wizpg.cpp
    - wizpg.h
    - wizpsh.cpp
    - wizpsh.h
tlsw_mfc_proj.zip
- tlsw_mfc
  - bin
    - RCStamp.txt
  - setup
    - eula.txt
    - tlswa.inf
    - tlswa.txt
  - tlsw.sln
  - tlsw
    - Controls.cpp
    - Controls.h
    - Dialogs.cpp
    - Dialogs.h
    - DmoSink.cpp
    - DmoSink.h
    - Main.cpp
    - Main.h
    - ReadMe.txt
    - res
      - Bullet.ico
      - fail.ico
      - success.ico
      - Task.ico
      - tlsw.ico
      - tlsw.manifest
      - tlsw.rc2
      - Warning.ico
      - WizHdr.bmp
      - WizMark.bmp
    - resource.h
    - stdafx.cpp
    - stdafx.h
    - tlsw.rc
    - tlsw.vcproj
    - VerInfo.cpp
    - VerInfo.h
    - Wizard.cpp
    - Wizard.h
    - WizPages.cpp
    - WizPages.h
tlsw_exe.zip
- tlswa.exe

Microsoft Visual Studio Solution File, Format Version 8.00
Project("{8BC9CEB8-8B4A-11D0-8D11-00A0C91BC942}") = "tlsw", "tlsw\tlsw.vcproj", "{9CB0B13D-486C-424E-BB90-E5FC50C072CE}"
	ProjectSection(ProjectDependencies) = postProject
	EndProjectSection
EndProject
Global
	GlobalSection(SolutionConfiguration) = preSolution
		Debug = Debug
		DebugU = DebugU
		Release = Release
		ReleaseU = ReleaseU
	EndGlobalSection
	GlobalSection(ProjectConfiguration) = postSolution
		{9CB0B13D-486C-424E-BB90-E5FC50C072CE}.Debug.ActiveCfg = Debug|Win32
		{9CB0B13D-486C-424E-BB90-E5FC50C072CE}.Debug.Build.0 = Debug|Win32
		{9CB0B13D-486C-424E-BB90-E5FC50C072CE}.DebugU.ActiveCfg = DebugU|Win32
		{9CB0B13D-486C-424E-BB90-E5FC50C072CE}.DebugU.Build.0 = DebugU|Win32
		{9CB0B13D-486C-424E-BB90-E5FC50C072CE}.Release.ActiveCfg = Release|Win32
		{9CB0B13D-486C-424E-BB90-E5FC50C072CE}.Release.Build.0 = Release|Win32
		{9CB0B13D-486C-424E-BB90-E5FC50C072CE}.ReleaseU.ActiveCfg = ReleaseU|Win32
		{9CB0B13D-486C-424E-BB90-E5FC50C072CE}.ReleaseU.Build.0 = ReleaseU|Win32
	EndGlobalSection
	GlobalSection(ExtensibilityGlobals) = postSolution
	EndGlobalSection
	GlobalSection(ExtensibilityAddIns) = postSolution
	EndGlobalSection
EndGlobal

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Armen Hakobyan

Software Developer (Senior) SafeNet Inc

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Shrinking SQL Server Transaction Logs with SQL-DMO

License

Comments and Discussions