Click here to Skip to main content
15,897,226 members
Articles / Desktop Programming / WTL

Shrinking SQL Server Transaction Logs with SQL-DMO

Rate me:
Please Sign up or sign in to vote.
4.99/5 (49 votes)
21 Apr 2004CPOL9 min read 206.3K   4.7K   70  
Using SQL-DMO to shrink SQL Server transaction logs.
//{{NO_DEPENDENCIES}}
// Microsoft Visual C++ generated include file.
// Used by tlsw.rc
//
#define IDR_MANIFEST                    1
#define IDM_ABOUTBOX                    0x0010
#define IDD_ABOUTBOX                    100
#define IDD_WIZPG_WELCOME               101
#define IDD_WIZPG_LOGIN                 102
#define IDD_WIZPG_SELDB                 103
#define IDD_WIZPG_SELTASKS              104
#define IDD_WIZPG_BACKUP                105
#define IDD_WIZPG_SHRINK                106
#define IDD_WIZPG_FINISH                107
#define IDD_WIZPG_READY                 108
#define IDR_MAINFRAME                   109
#define IDS_WIZPG_LOGIN_TITLE           110
#define IDS_WIZPG_LOGIN_SUBTITLE        111
#define IDS_WIZPG_SELDB_TITLE           112
#define IDS_WIZPG_SELDB_SUBTITLE        113
#define IDS_WIZPG_SHRINK_TITLE          114
#define IDS_WIZPG_SHRINK_SUBTITLE       115
#define IDS_WIZPG_READY_TITLE           116
#define IDS_WIZPG_READY_SUBTITLE        117
#define IDS_WIZPG_SELTASKS_TITLE        118
#define IDS_WIZPG_SELTASKS_SUBTITLE     119
#define IDS_WIZPG_BACKUP_TITLE          120
#define IDS_WIZPG_BACKUP_SUBTITLE       121
#define IDS_TOOL_ENTMAN                 130
#define IDS_TOOL_SRVMAN                 131
#define IDS_REG_CLIENTSETUP             132
#define IDS_REG_SERVERSETUP             133
#define IDP_UNKNOWN_ERROR               134
#define IDP_INVALID_STR                 135
#define IDP_INVALID_LST                 136
#define IDP_INVALID_MEDIASET            137
#define IDP_INVALID_MEDIASET_COUNT      138
#define IDP_INVALID_BACKUPFILE          139
#define IDP_INVALID_BACKUP_FILECOUNT    140
#define IDP_INVALID_SQL_VERSION         141
#define IDP_INVALID_OS_VERSION          142
#define IDP_QUERYEXIT                   143
#define IDP_DELETE_LOG                  147
#define IDB_WIZ_MARK                    151
#define IDB_WIZ_HDR                     152
#define IDR_MENU                        154
#define IDI_BULLET                      167
#define IDI_WARN                        168
#define IDC_CMD_MENU					1000
#define IDR_SERVER                      1002
#define IDC_CBO_SQLSRV                  1002
#define IDC_CHK_SQLSRVAUTH              1003
#define IDC_LBL_WELCOME                 1004
#define IDC_TXT_LOGIN                   1005
#define IDC_TXT_PASSWORD                1006
#define IDC_LBL_FINISH                  1006
#define IDC_CBO_SELDB                   1009
#define IDC_LST_TL                      1010
#define IDC_PRG_OVERALL                 1012
#define IDC_PRG_CURSTEP                 1014
#define IDC_TXT_SIZE                    1018
#define IDC_TXT_BACKUP_NAME             1019
#define IDC_TXT_BACKUP_DESC             1020
#define IDC_CHK_ADDJOB                  1024
#define IDC_CHK_SHRINK                  1025
#define IDC_CHK_BACKUP                  1026
#define IDC_SPN_SIZE                    1027
#define IDC_TXT_DATABASE                1029
#define IDC_CHK_BACKUP_VERIFY           1030
#define IDC_LST_BACKUP_FILES            1032
#define IDC_CMD_ADD                     1033
#define IDC_CMD_REMOVE                  1034
#define IDC_CHK_REPEAT                  1034
#define IDC_LBL_APP_TITLE               1043
#define IDC_LBL_APP_VERSION             1044
#define IDC_LBL_APP_COPYRIGHT           1045
#define IDC_LBL_APP_COMPANY             1046
#define IDC_CMD_MOREINFO                1048
#define IDC_LBL_TASK_CURSTEP            1054
#define IDC_LBL_TASK_OVERALL            1055
#define IDC_LBL_CANCELLED1              1057
#define IDC_LBL_COMPLETED               1058
#define IDC_LBL_CANCELLED2              1059
#define IDC_LBL_CLICKFINISH             1060
#define IDC_LBL_MOREINFO                1061
#define IDC_LBL_ERRORS                  1062
#define IDC_PIC_WARNING                 1063
#define IDM_ENTMAN                      32775
#define IDM_SVCMAN                      32781

// Next default values for new objects
// 
#ifdef APSTUDIO_INVOKED
#ifndef APSTUDIO_READONLY_SYMBOLS
#define _APS_NEXT_RESOURCE_VALUE        169
#define _APS_NEXT_COMMAND_VALUE         32784
#define _APS_NEXT_CONTROL_VALUE         1064
#define _APS_NEXT_SYMED_VALUE           104
#endif
#endif

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
Software Developer (Senior) SafeNet Inc
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions