home *** CD-ROM | disk | FTP | other *** search
/ CD Actual Thematic 7: Programming / CDAT7.iso / Share / Database / DBMaint / data1.cab / Program_Files / Dbmaint.inf < prev    next >
Encoding:
INI File  |  1999-04-06  |  11.6 KB  |  506 lines
  1. ;*********************************************************************************
  2. ; [Configurations]                                                               *
  3. ; Configuration name                                                             *
  4. ;*********************************************************************************
  5.  
  6. [Configurations]
  7. Database daily, transaction log every 4 hour
  8. Collect Performance Counter every 1 hour
  9. RePRINT on SQL Server 6.5 (from StreamServe)
  10. Hogia32 (Database daily, transaction log every 4 hour)
  11.  
  12. ;*********************************************************************************
  13. ; Definitions for every configuration listed under [Configurations]              *
  14. ;*********************************************************************************
  15.  
  16. [Database daily, transaction Log every 4 hour]
  17. ;Include Job(s)
  18. Job=NoLogBackup,WithLogBackup
  19. ;Include Task(s)
  20. Task=EveryNightAt0100,EveryFourthHour
  21.  
  22. ;Description for Configuration (max 254 char)
  23. Description=System databases db-backup nightly. Other databases db-backup nightly, log-backup every fourth hour.
  24.  
  25. ;Run SQL Script before configure Task,Job,Backup device ...
  26. Prerun=ExcludeFromAllGroup.SQL
  27.  
  28. ;Run SQL Script after configure Task,Job,Backup device ...
  29. Postrun=
  30.  
  31. [Collect Performance Counter every 1 hour]
  32. Task=Performance
  33. Description=A task that will run every 1 hour to collect SQL Server performance counters. The job will also (if necessary) create and configure performance (database).
  34.  
  35. [RePRINT on SQL Server 6.5 (from StreamServe)]
  36. Prerun=ExcludeFromAllGroup.SQL
  37. Job=RePRINT,NoLogBackup
  38. Task=Daily,Performance
  39. Description=Default settings for RePRINT 2.x.
  40.  
  41. [Hogia32 (Database daily, transaction log every 4 hour)]
  42. ;Include Job(s)
  43. Job=NoLogBackup,WithLogBackup
  44. ;Include Task(s)
  45. Task=EveryNightAt0100,EveryFourthHour,Performance
  46. Prerun=ExcludeFromAllGroup.SQL
  47. Description=Standard backup konfigurering f÷r Hogia32.
  48.  
  49. ;*********************************************************************************
  50. ;                List all Job configuration's                                    *
  51. ;*********************************************************************************
  52. [Job]
  53. ;Job Name=Keyname (of jobdefinition)
  54. NoLogBackup=NoLogBackup
  55. WithLogBackup=WithLogBackup
  56. RePrint=RePRINT
  57.  
  58. ;*********************************************************************************
  59. ;                Job configuration's                                             *
  60. ; 
  61. ; Syntax in job definition: 0=No, 1=Yes 
  62. ;*********************************************************************************
  63.  
  64. ;*********** Start of Job-definiton "NoLogBackup" ************************
  65. [NoLogBackup]
  66. ;Job Name
  67. Name=NoLogBackup
  68.  
  69. ;Database
  70. ;Include database(s), Database name, Database group or <All>
  71. ;Definitions of a Database group, see Database group section below
  72. Database=NoLogBackup
  73.  
  74. ;Type of database Group, Single or All.
  75. DatabaseType=Group
  76.  
  77. ;*************** 1: Preprocessing
  78. ;Run stored procedure
  79. ;Definition of a store procedure, see stored procedure below
  80. aPRCOCEDURE=sp_checkident
  81.  
  82. ;Terminate on error
  83. aTERMINATE=0
  84.  
  85. ;*************** 2: Data verification, Check
  86. ;Data linkage
  87. bCHECKDB=1
  88.  
  89. ;Index linkage
  90. bCHECKDBINCLUDEINDEX=1
  91.  
  92. ;Data allocation
  93. bCHECKALLOC=1
  94.  
  95. ;Index allocation
  96. bCHECKALLOCINCLUDEINDEX=1
  97.  
  98. ;Text/image allocation
  99. bCHECKTEXTALL=1
  100.  
  101. ;System tables
  102. bCHECKCATALOG=1
  103.  
  104. ;Run procedure after check, On success
  105. bPROCSUCCESS=
  106.  
  107. ;Run procedure after check, On failure
  108. bPROCFAIL=
  109.  
  110. ;Terminate on error
  111. bTERMINATE=
  112.  
  113. ;*************** 3: Backup
  114. ;Do backup
  115. cBACKUP=1
  116.  
  117. ;Append on error
  118. cAppendOnError=1
  119.  
  120. ;Run stored procedure after backup, On success
  121. cPROCSUCCESS=
  122.  
  123. ;Run stored procedure after backup, On failure
  124. cPROCFAIL=
  125.  
  126. ;Terminate on error
  127. cTERMINATE=
  128.  
  129. ;*************** 4: Optimizations
  130. ;Reorganize data
  131. dDBREINDEX=1
  132.  
  133. ;IF dFILLFACTOR=0 "Maintain original free space
  134. ;IF dFILLFACTOR>0 "Change free space too <value>
  135. dFILLFACTOR=10
  136.  
  137. ;Update index statistics
  138. dUPDATESTATISTICS=0
  139.  
  140. ;Recalculate space usage
  141. dRECALCSPACEUSAGE=1
  142.  
  143. ;Run procedure after optimizations, On success
  144. dPROCSUCCESS=
  145.  
  146. ;Run procedure after optimizations, On failure
  147. dPROCFAIL=
  148.  
  149. ;Terminate on error
  150. dTERMINATE=
  151.  
  152. ;*************** 5: Postprocessing
  153. ;Run stored procedure
  154. ePRCOCEDURE=
  155.  
  156. ;Backup to backupdevice, Definition of Backup device see section below
  157. Backupdevice=SystemDbBackup
  158.  
  159. ;*********** End of Job-definiton "NoLogBackup" ************************
  160.  
  161. ;*********** Start of Job-definiton "WithLogBackup" ************************
  162. [WithLogBackup]
  163. Name=WithLogBackup
  164. ;Database or Database group or <All>
  165. Database=<All>
  166. ;Group, Single, All
  167. DatabaseType=All
  168. bCHECKDB=1
  169. bCHECKDBINCLUDEINDEX=1
  170. bCHECKALLOC=1
  171. bCHECKALLOCINCLUDEINDEX=1
  172. bCHECKTEXTALL=1
  173. bCHECKCATALOG=1
  174. cBACKUP=1
  175. cAppendOnError=1
  176. dDBREINDEX=1
  177. dFILLFACTOR=10
  178. dUPDATESTATISTICS=0
  179. dRECALCSPACEUSAGE=1
  180. ePRCOCEDURE=sp_warn_if_full_db 80
  181. Backupdevice=UserDbBackup
  182. ;*********** End of definiton "WithLogBackup" ************************
  183.  
  184.  
  185. ;*********** Start of Job-definiton "RePRINT" ************************
  186. [RePRINT]
  187. Name=RePRINT
  188.  
  189. ;Database or Database group or <All>
  190. Database=StrsArchive
  191.  
  192. ;Group, Single, All
  193. DatabaseType=Single
  194. aPRCOCEDURE=remaint
  195. aTERMINATE=0
  196. bCHECKDB=1
  197. bCHECKDBINCLUDEINDEX=1
  198. bCHECKALLOC=1
  199. bCHECKALLOCINCLUDEINDEX=1
  200. bCHECKTEXTALL=1
  201. bCHECKCATALOG=1
  202. bPROCSUCCESS=
  203. bPROCFAIL=
  204. bTERMINATE=
  205. cBACKUP=1
  206. cAppendOnError=1
  207. cPROCSUCCESS=
  208. cPROCFAIL=
  209. cTERMINATE=
  210. dDBREINDEX=1
  211. dFILLFACTOR=10
  212. dUPDATESTATISTICS=0
  213. dRECALCSPACEUSAGE=1
  214. dPROCSUCCESS=
  215. dPROCFAIL=
  216. dTERMINATE=
  217. ePRCOCEDURE=
  218. Backupdevice=strsarchivedump
  219. ;*********** End of definiton "RePRINT" ************************
  220.  
  221. ;*********************************************************************************
  222. ;                Task configuration's                                            *
  223. ;                                                                                *
  224. ; Syntax in job definition: 0=No, 1=Yes                                          *
  225. ;*********************************************************************************
  226.  
  227.  
  228. ;[Schedule]
  229. ;Friday=dbschedule(bWeekly),dbweekday(5), logdo(N),logschedule(),loghourly(null)
  230. ;DailyLogFriDB=dbschedule(bWeekly),dbweekday(5), logdo(Y),logschedule(Daily),loghourly(null)
  231. ;DailyDB=dbschedule(bDaily),dbweekday(5), logdo(N),logschedule(Daily),loghourly(null)
  232. ;Hourly=dbschedule(bDaily),dbweekday(5), logdo(Y),logschedule(Hourly),loghourly(4)
  233.  
  234. ;*********** Start of Task-definiton "EveryNightAt0100" ************************
  235. [EveryNightAt0100]
  236. ;Task name
  237. Name=EveryNightAt0100
  238.  
  239. ;------ Schedule settings
  240. starttime=01:00
  241. stoptime=23:59
  242. ;dbweekly or dbDaily
  243. dbschedule=dbDaily
  244. ;1-7
  245. dbweekday=5
  246. ;0-1 (N-Y)
  247. logbackup=0
  248. ;Hourly or Daily
  249. logschedule=Daily
  250. ;1-12
  251. loghourfreq=4
  252. ;---- End of schedule settings
  253. ;0-1
  254. disconnectusers=0
  255. ;0-1
  256. unloadtape=0
  257. ;0-xx
  258. noofdumpgenerations=
  259. ;C:\temp\
  260. generationpath=
  261. ;0-1
  262. Overwrite=1
  263. ;1-7
  264. initday
  265. ;0-1
  266. nocheckwhentransactionbackup=0
  267. ;0-1
  268. checkdbnotbacked=0
  269. ;0-1
  270. performancecollect=0
  271. ;0-1
  272. lowdiskspacewarning=0
  273. ;0-1
  274. logtoserver=0
  275. ;0-1
  276. logtoemail=0
  277. ;0-1
  278. logtoeventlog=1
  279. ;0-1
  280. logtosnmp=0
  281. ;0-1
  282. logtoprinter=0
  283. ;0-1
  284. serverreport=0
  285. Jobnames=NoLogBackup
  286. ;*********** End of Task-definiton "EveryNightAt0100" ************************
  287.  
  288. ;*********** Start of Task-definiton "EveryFourthHour" ************************
  289. [EveryFourthHour]
  290. ;Task name
  291. Name=EveryFourthHour
  292.  
  293. ;------ Schedule settings
  294. starttime=00:00
  295. stoptime=23:59
  296. ;dbweekly or dbDaily
  297. dbschedule=dbDaily
  298. ;1-7
  299. dbweekday=5
  300. ;0-1 (N-Y)
  301. logbackup=1
  302. ;Hourly or Daily
  303. logschedule=Hourly
  304. ;1-12
  305. loghourfreq=4
  306. ;---- End of schedule settings
  307. ;0-1
  308. disconnectusers=0
  309. ;0-1
  310. unloadtape=0
  311. ;0-xx
  312. noofdumpgenerations=
  313. ;C:\temp\
  314. generationpath=
  315. ;0-1
  316. Overwrite=1
  317. ;1-7
  318. initday
  319. ;0-1
  320. nocheckwhentransactionbackup=1
  321. ;0-1
  322. checkdbnotbacked=0
  323. ;0-1
  324. performancecollect=0
  325. ;0-1
  326. lowdiskspacewarning=0
  327. ;0-1
  328. logtoserver=0
  329. ;0-1
  330. logtoemail=0
  331. ;0-1
  332. logtoeventlog=1
  333. ;0-1
  334. logtosnmp=0
  335. ;0-1
  336. logtoprinter=0
  337. ;0-1
  338. serverreport=0
  339. Jobnames=WithLogBackup
  340. ;*********** End of Task-definiton "EveryFourthHour" ************************
  341.  
  342.  
  343.  
  344. ;*********** Start of Task-definiton "Performance" ************************
  345. [Performance]
  346. Name=PerformanceCollect
  347.  
  348. ;------ Schedule settings
  349. starttime=00:00
  350. stoptime=23:50
  351. ;dbweekly or dbDaily
  352. dbschedule=dbDaily
  353. ;1-7
  354. dbweekday=5
  355. ;0-1 (N-Y)
  356. logbackup=1
  357. ;Hourly or Daily
  358. logschedule=Hourly
  359. ;1-12
  360. loghourfreq=1
  361. ;---- End of schedule settings
  362. ;0-1
  363. disconnectusers=0
  364. ;0-1
  365. unloadtape=0
  366. ;0-xx
  367. noofdumpgenerations=0
  368. ;C:\temp\
  369. generationpath=
  370. ;0-1
  371. Overwrite=1
  372. ;1-7
  373. initday
  374. ;0-1
  375. nocheckwhentransactionbackup=0
  376. ;0-1
  377. checkdbnotbacked=0
  378. ;0-1
  379. performancecollect=1
  380. ;0-1
  381. lowdiskspacewarning=0
  382. ;0-1
  383. logtoserver=0
  384. ;0-1
  385. logtoemail=0
  386. ;0-1
  387. logtoeventlog=0
  388. ;0-1
  389. logtosnmp=0
  390. ;0-1
  391. logtoprinter=0
  392. ;0-1
  393. serverreport=0
  394. ;*********** End of Task-definiton "Performance" ************************
  395.  
  396. ;*********** Start of Task-definiton "Daily" (used by StreamServe) ******
  397. [Daily]
  398. Name=Daily
  399. starttime=00:00
  400. disconnectusers=0
  401.  
  402. ;dbweekly or dbDaily
  403. dbschedule=dbDaily
  404.  
  405. logbackup=0
  406. ;1-7
  407. dbweekday=5
  408. ;Hourly or Daily
  409. logschedule=Daily
  410.  
  411. ;1-12
  412. loghourfreq=
  413. ;0-1
  414. unloadtape=0
  415. ;0-xx
  416. noofdumpgenerations=1
  417. generationpath=Default
  418. ;0-1
  419. Overwrite=1
  420. ;1-7
  421. initday
  422. ;0-1
  423. nocheckwhentransactionbackup=1
  424. ;0-1
  425. checkdbnotbacked=0
  426. ;0-1
  427. performancecollect=0
  428. ;0-1
  429. lowdiskspacewarning=0
  430. ;0-1
  431. logtoserver=0
  432. ;0-1
  433. logtoemail=0
  434. ;0-1
  435. logtoeventlog=1
  436. ;0-1
  437. logtosnmp=0
  438. ;0-1
  439. logtoprinter=0
  440. ;0-1
  441. serverreport=0
  442. Jobnames=NoLogBackup,RePRINT
  443. ;*********** End of Task-definiton "Daily" (used by StreamServe) ******
  444.  
  445.  
  446. ;*********************************************************************************
  447. ;                Backup devices                                                  *
  448. ;*********************************************************************************
  449. [BackupDevices]
  450. ;Devicename=Devicetype (Disk or Tape), Path to diskdevice (default Sqlserver-path\Backup)
  451. SystemDbBackup=Disk
  452. UserDbBackup=Disk
  453. ;For RePRINT
  454. strsarchivedump=Disk
  455.  
  456. ;*********************************************************************************
  457. ;                Database Groups                                                 *
  458. ;*********************************************************************************
  459. [DatabaseGroups]
  460. ;Groupname=database[,database,.....]
  461. NoLogBackup=master,model,msdb
  462.  
  463. ;*********************************************************************************
  464. ;                Stored procedures                                               *
  465. ;*********************************************************************************
  466. [Stored Procedures]
  467. ;Name=xxx.sql,Database
  468. sp_checkident=sp_checkident.sql,master
  469. sp_warn_if_full_db=sp_warn_if_full_db.sql,master
  470. remaint=remaint.sql,StrsArchive
  471.  
  472. ;*********************************************************************************
  473. ;                Performance Configuration                                       *
  474. ;*********************************************************************************
  475. [Performance Configuration]
  476. ;Name of database device, MS SQL 6.50 ONLY.
  477. DbDeviceName=perfdbdev
  478.  
  479. ;Size of database device, MS SQL 6.50 ONLY.
  480. DbDeviceSize=3072
  481.  
  482. ;Name of log device, MS SQL 6.50 ONLY.
  483. LogDeviceName=perflogdev
  484.  
  485. ;Size of log device, MS SQL 6.50 ONLY.
  486. LogDeviceSize=3072
  487.  
  488. ;Filename for database device (6.5) or Database filename (7.0)
  489. DbFileName=
  490.  
  491. ;Filename for log device (6.5) or Log filename (7.0)
  492. LogFileName=
  493.  
  494. ;Database name
  495. DataName=Perfdata
  496.  
  497. ;Log name
  498. LogName=Perflog
  499.  
  500. ;Size of database
  501. Datasize=5
  502.  
  503. ;Size of log
  504. Logsize=5
  505.  
  506.