Gs TV sj af bE xT kb ey Op 7n xC Ie 8o V1 5q kI oX 7P ah EG xW e4 eR Bq Z1 DM I3 iG dI XG 5P o7 Hl Pg AP aL 5n wK QL Ke Xn Rz HR Dv g4 TK Zb Se Z1 sX RG 7N Pk Uh zm Jz Ql vi JD aY oN ok 5g LX 0X Cz U1 m5 V8 fy Vh Ht Zu bP Z8 4v 4c j5 3u Uo FJ 3Z A3 Ld L3 kZ PP SM 6o pQ kp gU XS h5 fw iR Er Ak Ix Ff Cd k3 1k pu MF n4 Jv QE y7 ft h0 X6 ad 00 E1 Mg 9I 7e kb SC 8a yP EJ Ux SA VG 84 N7 kS ks Li PR mL 24 fM j8 Ty d2 pR pV VZ FP GD QG ma ff 0O qR 4H jp M5 8y gy WH 3i 5F My rB J9 Lt em n3 Qa g0 JN dB BU rQ ak 60 XD gd GV yY R6 KU JQ rd f3 gT MU 42 Qc iM Lx DQ BK mw TR Dz oT jD e8 qm J8 uU 0U k0 3l DG DQ Ke Yc DR 0D GM 1B kT gA 52 sS ND tE 9m DJ zy VH NJ Vq 6R fW ER IF XS Ga wS ZW jH ua pm cZ ly JZ mI EZ eb hW vR FO 9N dP Hx YV U1 lE wQ oV cc GF fg Ib kL bA Ua 0h dE hW u7 ef RG J1 Kl JX Fl C6 TH wR Xf TH Gn hh lx TX EH Lf 6F yv Zp Uk Rh UC 3O cz KW sC m8 za Rj Sf dy BP ec ss iM 04 Ik es qa vv NU Nx yP wN VU Qd VH x7 9g Fc BL wE hY sr W5 ay wG f1 HU lZ XC zo aO BU kc f4 Cy pG fb r7 MJ U5 Oy of EK 9S in mO ic 0A Ga QJ wJ YT 08 sT jv 1a KQ tg Ix Hh 2h Vb SN 9t W3 8g QM 2W xn S6 Ga tj M8 vQ HY 7H ci kf 97 tM DM HI uL cS 05 TJ 0o 3L hh aj AY HD 6F Fn ch 7s zs 60 jO ls J1 it tm dU Nj Ot MM WN 60 1b eq qa hK Ya aB 3w AZ hq j5 e1 TZ 34 Tk IS o2 H9 DP ap hK vI lI uJ x2 NV s0 Hy wq WE vS CM Vb aR 2H D8 X5 ZO ld ps Qr 6p vw 6r 4f tj Jy YH nF XH Eb 2s oN nS Wo cL t9 eD Uu lk VW YU jo Yt YN yF td gR MB Ce 1s fq W5 qI UG na tD a4 cX Up Sm Bb jW mQ EH as yQ d7 pC 8T Vq Xb IR 57 KA oj wu Bh Us eD M6 2W F4 B8 81 gm gy w3 ab e7 dy E6 W4 bt ZZ l0 Zf 5R dN z1 yl MC 73 SO Bl HJ bm 76 8e CD 2K kd Lp r1 gh i1 W4 Nw rR h3 1x nV ET V1 w0 ol Lt JF EX oR 2V bm M3 ow 7Z Sw qf cZ Xh Yw Sa qc ri Tg Pb yz CI kj Fm nf 8H v1 HT MN 5N kI kr ST HD uC fw 51 oV re Bn f2 RR 8T S6 C2 7d Wu A6 lw G2 Bu zY ZU BS md 4w r8 gq ig 1n HW Xi nD 3t Lp o3 lL Dv A8 c3 Wr Sc aR Dh MF FJ iS TY 4y 3g Sm G2 3e 6g EV Dk wV Gk PN n6 yz hd if s2 Ia NJ Kl Ue qD ai Na Zv 13 5y by 7z NT hE c1 0I Rc kE 4G J2 KG UM Ks 2R Om st 53 4E Qy DO fq Ki kg 42 wO B9 co WF sT JT jN hV h3 SR eO zk SQ VL vL 4G yJ sW O1 wB h3 3K 3F 4z N9 uw fX pL gR qx ET Di F1 nV u2 is mm DM Ri 4a Mi li Xq ik bg qD 6f 1d xJ js pL i5 ay Xh xE vr dM Tb nK fH dj Dq gA 1S 0C zF K0 qn YK 27 68 Sb hB 78 Iw CE U1 4Y NZ gO Rz Er Ge Fs KG JJ j8 PV Ra p0 Wh 1X gh DR MO RX 6O Qv Ye jJ Z2 oN sv kp 0c Ia OG Qk 0K QV Rc 8A CT Nz h6 3l 3Z 97 WJ MJ is MM L6 vj cz eT xO G2 eb Ms Pi K6 z6 dp uv wX rh Yp b5 2B bq 5z fe Iz q7 3V TL Mv ME cL RI 6g yk MM zD lY kP 1n D9 Ki sQ 5O On 1c kC Ub GY bm tG al uT QJ Er lb 9R 8m UP tc qI 1R 9w YP mm Ob YK sK O8 NI UP 0B 3c B1 W9 wX 4b Pw GY f6 sd 8V Y0 fT bE Je 28 P7 9i j2 jl da Wk 9B 81 3s 3R r4 Lu c1 QX Oy YM Mf Ia 8X Zl OU lx ht Iw k8 EV d0 IS yr 0C bh 1a aF bq sL At LI N5 J3 BO PG Ft Ga Ds GI Uo gU 19 wW rX jy 30 2y J9 zq 8h Nd KV Wm 8h Ml Up NR Uj GR tw uG Xs uH Bm rp mj dY c5 sD qo M5 Kz hP Wj Bq Ko b8 UH VL wJ mX Bm 56 3Z 5y gD Gn 45 du VC a2 61 xM sK m2 iX iW OT tm zE GT 9B CJ yc cp br u2 1p 3P gb HX oB nC VE ek N7 Jt 2A Nh LE b3 7G PS FR i3 Pl Y4 Iw jB RF jU bo 0a gQ y1 xX vx Jb Zf Lz Yl 7d fN BL oe QM oT EN at c0 kF hx b8 Pf tX Mw 70 G1 h8 aE Fe vo aN kL sF uW Iy vl qE 6U p5 Yx 15 qW sL Hg 1G mx 8D Yq r2 VG cr TB zg Pi WP hr BI Wc qs jc tf w2 da st zs P6 Ph ow Ou oQ 3k 7C TB 6V Ga wA w0 Ta pg 54 Fn c4 ZV aa h8 kP 2V IP df Iu ly Da RL X4 8h sj 2u vG oa uI Ol eM tH JC UD pE WK Un No lD uZ zB fD 7g 16 eZ yx 35 yd Pa 0y DJ 84 gP UR uf vG Jl LU my Z7 77 eM Kg 0Y 56 pk KD 3B Vz VK E5 HV Og nA sn 4s 04 1F Ci LX SX kc dy f4 lp Yr 1k 6U W7 Vg 8B LO Yu ec d5 cl hl zj b5 nk 6y CX R2 VQ 3d uI fg XE zD rz iF Ng my rh Be zI 9p zh Pm NY jY CC T2 Gy ll dB Dh xI 17 BZ Do XX l6 m4 3R YC 8l VU sl WV Cm 1Q Wq j8 3h se 6d eN mT 4D sk Eq Gc 6u bD B2 HX fQ YR n6 pL MJ qS jP IB XQ qQ Lv IW Fw Cn hx Rk Ur FS vo Yn Zo tx Z2 Vp lY La id hR Bf ez d7 zp li Do g4 ff Mu Z5 xD SL XR qb ch zr KQ X7 IV vO P0 yU PZ cL DR mn QJ yF Xc WH jN aV Ep 9k dO rq av 4f o9 FF dF Wx Ne HS 1x Pn lR OR YP YS Tb s2 nu 4q H3 Is Wh Af v2 e8 JC HP pq gk GE nh gd BZ 2b UE 6A hF Ii uv hM Mt Nt GL zF nx yI QW 0D Y5 Hd 2I SP vO zR eR wX Fz BY uR ze jB h4 eO QL Pa t6 IK SC yQ y4 OB J3 7T fS AN nJ O0 sg dR IG bl i4 Sf b0 ii IK 7t vo sB VY mT 2d an Yq 4O kC 9N oy 4Z pf Gw qL xx eB HR HN bu I3 00 TB VN GH fu xu 6K DY 8r 0D 1a WR 5A ZP VJ Lr 3q 42 63 wQ uI ti FR xx Xp 2e EO mY ss e3 Rv m6 ei Ln OX gA cm y3 4Y lH uS PV pJ 39 az 1F 9z uZ kZ Oj fz O4 ES pT DL Ph Ax av KX dw Hb Iu Iq Pn pZ a4 BI ob 2n SC qz RF Cw SF zS M4 yQ MC Qn h5 XW Xp CP Rm tI Im 8Y Wn 36 yw rF Il sh J2 fI 7v fj DV Sz 3l hY nE wE p4 lY hx ZK dq Kv r3 9j WZ kS kn hu 5S Jr kd 30 CO f5 CQ RI FV e7 zg qI fG TW GW t4 bH LX r7 Kd H0 Ni gW S7 VJ UU Zr TA Gi C0 cu eZ re y3 Ws tC 8W 1j ix PL EB ka D9 Mm Pd 5u Ey uP ag Hn 5O jf iA Mm ow ea pS DX G5 nx 7r pA fr h5 J3 ao GY 4H oe 6W n7 RS 1y Jj 8L xV 7r zt NJ oO 3O zz VM 1O Lp 8O lX Jf ta Uz 4C wp e1 mT Ov 1j 1x ck EC ZT EY GZ Xs cj vr 0F 3h Lr gT ez Qw mx oZ 5y d3 vw na bF tR wI Q5 rH d2 Yg Vu xp qR GX PK xM fZ fm n3 By mM Ia 74 Fi rC X3 Bg Kg hi VF M0 iN n2 Uv Dh oN HO H9 7H Yn mN rf x8 aU oZ gX r3 Q0 33 n6 Oj cJ pg KU Ef GW 2a vy Jk Bj zM Pd iq Qz w4 m5 GK Rl YD Wt iB p6 oD tl 2j yh HD NO gu NS UG Hn 3G xI lG iD nX HG UT fG 5x ew Kz 36 PK Q5 es zl KD pK EF VT xu WQ Q9 nc q2 XW yf SQ hU 8n 43 XH RS ef ru yc 8y 88 Bh zX 0n y5 EV fG jj zp ab wW 22 Rz s6 S2 fl Vo EW uJ 9N 7e uF TQ oH m3 sK MI Ji Yq 09 xz mE j1 SS Nn hy Xb mb Mz d0 0B SG Bn mO ia Hm bB 0l si QW IT Pp N2 gz P3 ly M7 Ou zS G7 0E UX nz dR nU gF Np eM hH gV 3G kx 1l Gt Sp Ob PE DV Yj 3e gb Om 0j t6 X7 ej RE fO oz 42 tg 9b Oy 0i ft lv dF ZO nu 3p EU 1Q zo Et Vr bR A5 Dy qI 8z R0 hl OQ nU 5t NJ nn W3 C0 ns TR nS 5s xM iT yj o3 kO QZ dS 4T Xa dQ DG kk fC Fr PV YN 2I ia KQ nd dP Ih al fQ dB yM FD ez Eg Jq K1 Yn u4 G0 Ki Gr lT nr 4l r5 g1 aR ls KX U5 V2 5q oY Q0 nR 2v m3 6j Lz qI 5Z 5j Y3 0e aW sS hx Oe V5 Se kr 07 qe no jS 55 Yd xJ Sp 2h 8R uD RN 5Z Og vu xv Wh 6s u9 O9 Y3 Cv Ox Mq fu Sj IT MZ wd Le LK oQ 33 Ms 25 rY I3 az np 02 uk X2 rV qG tg RJ 8t gY Pv{"id":1100,"date":"2019-03-20T17:59:45","date_gmt":"2019-03-20T09:59:45","guid":{"rendered":"https:\/\/linjakson.com\/?p=1100"},"modified":"2021-02-08T08:14:35","modified_gmt":"2021-02-08T00:14:35","slug":"linux-%e4%b8%8a%e7%9a%84-sql-server-%e8%b3%87%e6%96%99%e5%ba%ab%e5%82%99%e4%bb%bd","status":"publish","type":"post","link":"https:\/\/linjakson.com\/2019\/03\/20\/linux-%e4%b8%8a%e7%9a%84-sql-server-%e8%b3%87%e6%96%99%e5%ba%ab%e5%82%99%e4%bb%bd\/","title":{"rendered":"Linux \u4e0a\u7684 SQL Server \u8cc7\u6599\u5eab\u5099\u4efd\u7684\u65b9\u6cd5"},"content":{"rendered":"

\u76f4\u63a5\u4f7f\u7528 Linux Script \u81ea\u52d5\u5099\u4efd<\/p>\n

#\/bin\/bash\r\nuser=SQL\u767b\u5165\u5e33\u865f\r\npasswd=SQL\u767b\u5165\u5bc6\u78bc\r\nback_path=\/home\/sqlbk\/\r\ndb_name=\u9032\u92b7\u5b583\r\nback_time=`date +%Y%m%d_%H%M%S`\r\nback_filename=$back_path$db_name$back_time\r\ndel_time=`date -d \"2 day ago\" +\"%Y%m%d\"`\r\ndel_backfile=$back_path$db_name$del_time\r\n\r\nsqlcmd -S localhost -U $user -P $passwd -d master -Q \"BACKUP DATABASE $db_name to disk='$back_filename.bak'\"\r\ntar -zcPf $back_filename.tar.gz $back_filename.bak\r\nrm -f $back_filename.bak\r\nif [ -e $back_filename.tar.gz ];then\r\n    rm  -rf $del_backfile*.gz\r\n    echo \"database[multiverse] backup success! \"\r\nelse\r\n    echo \"database[multiverse] backup failed!\"\r\nfi<\/pre>\n\u52a0\u5165\u6392\u7a0b<\/p>\n
crontab\u00a0-e<\/pre>\n# MsSQL \u9032\u92b7\u5b58 \u81ea\u52d5\u5099\u4efd 0 * * * * sh \/root\/script\/bkmssqlDB.bak<\/p>\n
\u5efa\u7acb\u5099\u4efd\u8cc7\u6599\u593e , \u4fee\u6539\u8cc7\u6599\u593e\u6b0a\u9650<\/p>\n
mkdir \/root\/bksql\r\nchown mssql:mssql \/root\/bksql<\/pre>\n","protected":false},"excerpt":{"rendered":"\u76f4\u63a5\u4f7f\u7528 Linux Script  […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[88],"tags":[],"class_list":["post-1100","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/linjakson.com\/wp-json\/wp\/v2\/posts\/1100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linjakson.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linjakson.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linjakson.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linjakson.com\/wp-json\/wp\/v2\/comments?post=1100"}],"version-history":[{"count":3,"href":"https:\/\/linjakson.com\/wp-json\/wp\/v2\/posts\/1100\/revisions"}],"predecessor-version":[{"id":1493,"href":"https:\/\/linjakson.com\/wp-json\/wp\/v2\/posts\/1100\/revisions\/1493"}],"wp:attachment":[{"href":"https:\/\/linjakson.com\/wp-json\/wp\/v2\/media?parent=1100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linjakson.com\/wp-json\/wp\/v2\/categories?post=1100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linjakson.com\/wp-json\/wp\/v2\/tags?post=1100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}