ࡱ > h j g 5@ bjbj22 X X ` 8 l ( . f h h h h h h $ S R | " . U + + + . f + f + $ + O v | b J . PX| J 0 ! ^ ! $ ! * + + WinSales SQL Server 6.5 Database Maintenance & Automated Backup Tips WinSales Version: 4.x Revised: 1/8/02 Support Document: sup064 We recommend that you create stored procedures in SQL Server 6.5 to backup and re-index your database on a regular basis to maximize performance and reduce risk of problems with your database. Refer to your SQL Server 6.5 documentation for further details. Daily backup: This daily task is created as a CMDExec and run daily. The drive letter will need to be modified based on database location: SQLMAINT.EXE -D SilentPartner -CkAl -BkUpLog D:\MSSQL\BACKUP -BkUpMedia DISK -Rpt D:\MSSQL\LOG\ SilentPartner_maint.rpt Weekly backup: This weekly task is also created as CMDExec and run weekly. The drive letter will again need to be modified based on the database location: SQLMAINT.EXE -D SilentPartner -UpdSts -Rebldldx 10 -BkUpDB D:\MSSQL\BACKUP -BkUpMedia DISK -DelBkUps 1 -Rpt D:\MSSQL\LOG\ SilentPartner_maint.rpt This is TSQL command is used for rebuilding indexes: update_statistics sqlmaint -D SilentPartner -RebldIdx 10 -Rpt D:\MSSQL\LOG\ SilentPartner _maint.rpt There is an issue in SQL 6.5 before Service Pack5a that can cause user count problems after a rebuild of the index. Be sure you are running SP5a or higher before enabling this process. For assistance on maintenance and backup of SQL Server 7.0 and 2000 databases please refer to the SQL Server Enterprise Manager documentation. FILENAME \p C:\tempTechnotes\sup064.doc Last printed PRINTDATE 1/27/2000 11:28 AM Silent Partner, Ltd 425-831-7915 HYPERLINK "mailto:support@winsales.com" support@silentpartner.com www.silentpartner.com F H + , U V o p ȻȻȻȬȨnn^nZ h*6 h*6 0J CJ OJ QJ ^J aJ #j h*6 CJ OJ QJ U^J aJ h*6 CJ OJ QJ ^J aJ hXO- h mH nH u j hXO- Uh hXO- h hXO- hXO- 5CJ OJ QJ \^J hXO- 5CJ OJ QJ ^J hXO- CJ OJ QJ ^J hXO- 6>*CJ OJ QJ ]^J 6j hXO- 6>*CJ OJ QJ U]^J hmH nH u! # G H ^ n 0 1 _ ` 7$ 8$ H$ + q 7$ 8$ H$ gd*6 $a$gd*6 $ !#a$ hXO- CJ OJ QJ ^J hXO- h*6 hXO- # 0 P / =!"#$% n^u #N_(]PNG IHDR R 7Y gAMA pHYs + IDATxˏeUƿo}N=c[PD ,bƈ)Ab !/ )BHQ&LB@By8qmU]`{vUݿjխ:Z{.JBX%n@Ѹ47+G^;ՎFq,n{dhMdhMdhMdhMdhMdhMdhMdhMdhMdhMdhMdhԻ]#xg9Wq+R9S,Duזve~qaUtZ̿~ǧ6zqw]3gǙx#9u~lnAˑŞΓ#Wk \/.۳d:,mG;8 ggt`&|LTtܝo[ȁ+ǵ_Ҫ=e_[@_nYI$U/_ ,K-ÁwoޓpC,8Isyڛw7>nz$DžNNU-?UO5Xs3GGv j^yq㧭h9g:|ᴏpt7*8BVqnM\c^ q{=@}t|ҸgiA~ާƪdhMq&?OwE hF .df@R#N L. 3@0qu Fr3mY P