Click here to Skip to main content
15,896,111 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.1K   4.7K   70  
Using SQL-DMO to shrink SQL Server transaction logs.
//{{NO_DEPENDENCIES}}
// Microsoft Developer Studio generated include file.
// Used by tlswa.rc
//
#define IDM_ABOUTBOX                    0x0010
#define IDD_ABOUTBOX                    100
#define IDD_WIZ_INTRO                   101
#define IDD_WIZ_LOGIN                   102
#define IDD_WIZ_SELDB                   103
#define IDD_WIZ_TASKS                   104
#define IDD_WIZ_BACKUP                  105
#define IDD_WIZ_READY                   106
#define IDD_WIZ_SHRINK                  107
#define IDD_WIZ_FINISH                  108
#define IDS_HT_LOGIN                    110
#define IDS_HS_LOGIN                    111
#define IDS_HT_SELDB                    112
#define IDS_HS_SELDB                    113
#define IDS_HT_TASKS                    114
#define IDS_HS_TASKS                    115
#define IDS_HT_BACKUP                   116
#define IDS_HS_BACKUP                   117
#define IDS_HT_READY                    118
#define IDS_HS_READY                    119
#define IDS_HT_SHRINK                   120
#define IDS_HS_SHRINK                   121
#define IDR_MAINFRAME                   128
#define IDS_ABOUTBOX                    129
#define IDS_MINIMIZE                    130
#define IDR_SRVMAN                      131
#define IDR_ENTMAN                      132
#define IDS_WIZ_CANCEL                  133
#define IDS_WIZ_ERRORS                  134
#define IDS_WIZ_SUCCESS                 135
#define IDP_BK_REMOTE                   136
#define IDP_INVALID_USER                140
#define IDP_QUERYCANCEL                 141
#define IDP_INVALID_SQLVER              142
#define IDP_TASKS                       144
#define IDP_INVALID_STR                 145
#define IDP_INT_RANGE                   146
#define IDP_INVALID_SQLVER2             147
#define IDP_INVALID_BKFILECOUNT         148
#define IDP_INVALID_BKFILE              149
#define IDP_BKFILES                     150
#define IDP_UNKNOWN_ERROR               151
#define IDS_PRG_START                   160
#define IDS_PRG_JOBSVR                  161
#define IDS_PRG_JOB                     162
#define IDS_PRG_ALERT                   163
#define IDS_PRG_BACKUP                  164
#define IDS_PRG_SHRINK                  165
#define IDS_PRG_VERIFY                  166
#define IDS_PRG_FINISH                  167
#define IDS_PRG_CUR                     168
#define IDS_PRG_ALL                     169
#define IDS_PRG_CANCEL                  170
#define IDB_WIZ_MARK                    202
#define IDB_WIZ_HDR                     203
#define IDI_BK                          205
#define IDM_MENU                        227
#define IDC_CMD_MENU                    1002
#define IDC_CHK_SYSDB                   1003
#define IDC_LBL_WELCOME                 1004
#define IDC_CHK_SQLSTART                1004
#define IDC_LBL_FINISH                  1006
#define IDC_TXT_PWD                     1006
#define IDC_RAD_WINAUTH                 1007
#define IDC_RAD_SQLAUTH                 1008
#define IDC_CBO_DBS                     1009
#define IDC_CBO_SRV                     1010
#define IDC_LST_TLS                     1011
#define IDC_PRG_ALL                     1012
#define IDC_PRG_CUR                     1014
#define IDC_CMD_BKADD                   1016
#define IDC_LBL_APPTITLE                1017
#define IDC_CMD_BKDEL                   1018
#define IDC_LBL_APPVER                  1018
#define IDC_LBL_BULT1                   1018
#define IDC_LBL_APPCOPYRIGHT            1019
#define IDC_CMD_BKPROP                  1019
#define IDC_LBL_BULT2                   1019
#define IDC_TXT_SIZE                    1020
#define IDC_LBL_APPCOMPANY              1020
#define IDC_LBL_BULT3                   1020
#define IDC_TXT_BKNAME                  1021
#define IDC_LBL_APPDPT                  1021
#define IDC_TXT_BKDESC                  1022
#define IDC_LBL_LINE1                   1023
#define IDC_CHK_JOB                     1024
#define IDC_CHK_SHRINK                  1025
#define IDC_CMD_DBPROP                  1026
#define IDC_SPN_SIZE                    1027
#define IDC_TXT_UID                     1027
#define IDC_CHK_BACKUP                  1028
#define IDS_LNK_URL                     1028
#define IDC_TXT_DBNAME                  1029
#define IDC_RAD_APPBK                   1029
#define IDC_CHK_BKVER                   1030
#define IDC_RAD_SQLBK                   1030
#define IDC_GP_BACKUP                   1031
#define IDC_LST_BKFILES                 1032
#define IDC_CHK_REPEAT                  1034
#define IDC_LBL_PRGCUR                  1054
#define IDC_LBL_PRGALL                  1055
#define IDC_LBL_COMPLETED               1058
#define IDC_LBL_LINE2                   1059
#define IDC_LBL_CLICKFINISH             1060
#define IDM_HELP                        32784
#define IDM_ABOUT                       32787

// Next default values for new objects
// 
#ifdef APSTUDIO_INVOKED
#ifndef APSTUDIO_READONLY_SYMBOLS
#define _APS_NEXT_RESOURCE_VALUE        229
#define _APS_NEXT_COMMAND_VALUE         32789
#define _APS_NEXT_CONTROL_VALUE         1032
#define _APS_NEXT_SYMED_VALUE           101
#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