-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathEvolutions-and-mitigations-2019---from-prod-views.html
More file actions
57 lines (45 loc) · 15.1 KB
/
Evolutions-and-mitigations-2019---from-prod-views.html
File metadata and controls
57 lines (45 loc) · 15.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width" />
<title>Evolutions and mitigations 2019 - from prod views</title>
<meta name="twitter:title" property="og:title" content="Evolutions and mitigations 2019 - from prod views">
<meta name="twitter:description" property="og:description">
<meta property="og:url" content="https://docsroot.github.io/Evolutions-and-mitigations-2019---from-prod-views.html">
<meta property="og:type" content="website">
<meta property="og:site_name" content="DocsRoot">
<meta name="author" content="hu****hd@gmail.com" />
<meta name="creator" content="docsroot" />
<style type="text/css">
blockquote {
border-left: 5px solid green;
margin: 10px;
padding: 10px;
}
img {
max-width: 100%;
height: auto;
}
footer {
position: fixed;
left: 0;
bottom: 0;
width: 100%;
background-color: #DDD;
text-align: center;
height: 22px;
line-height: 22px;
}
</style>
</head>
<body>
<!--Heading of the page-->
<h1>Evolutions and mitigations 2019 - from prod views</h1>
<!--The body part: what you put into RTE-->
<p>This page I'll list all new tasks and fixes applied to my (working) solutions</p><h2>A/ For evolutions</h2><h3>a1. How to gain disk space on servers</h3><p>I have servers that log files / backup files are increasing, and sometime it could consume almost of spaces of the drive but this is a must to keep them. The servers are Windows with Powershell installed. So I have done:</p><ul><li>Develop a script which identifies the files to be archived (compress them maximally and delete raw files)</li><li>Keep raw files (don't archive) within specific days for easiler accessing when needed</li></ul><p>So the solution is: Powershell + 7-zip</p><h2>B/ For the fixes and mitigrations</h2><p>b1. How to fix log file of tempdb when it reaches to max size?</p><p>When this happens, it's not possible to use UI (through SSMS) to check it / edit the size. So below are scripts needed to handle:</p><p>Watch for current used % of log files</p><blockquote>DBCC SQLPERF(logspace)<br></blockquote><p><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAARAAAACzCAYAAABB9UPhAAAgAElEQVR4Ae2d32skx7XHvwr+M/ZXgkYPuuO9+3bXs/GPBIORFoMMjvxgO0suZETAIO3DYogXjEE21+zDSmAIUiDBdvbBiiELRqO7YBLHtuS9b3vXc/dhZ0jWa/8N9/HO5VR3dVd11+mulmbU1ZojsKe7uvrUqc/pPtNVvfWdGQAjALhw7VP86dVTeHzr11i88S0VRX/nr6L30Ss48/0neO3Fm7iXLcc3eOfCVfxZlT+JNz/7PV4/DcuOtq1P1Z+f3v5PfPHFF/hg4z90kXwKASHQIAIz/Xt3VQKp5PPX76P9xTPoX3+q0mnZypJAskRkXwg0i8ATfu6aTxl0Bj1pvOl3qtQSAkLgxBLwTCBP4e17d/H2icUgHRMCQuAwBH50mJPkHCEgBIQAEZgZjUbV50CEnRAQAkIAwBP/89//JSCEgBAQAoci8AS9CZE/ISAEhMBhCDxB/w5D/oSAEBAChyEw9jmQn/3sZ/jb3/52GF/kHIOAcDRgNHiziXGs4vNY50CywyGZXznclS8cD8cttLOaGMesz2VM5TVuGSE5LgSEAEtAEgiLRg4IASFQRuB4EwgtyPvlJ3hc5lXV42T3wkW04//e+bqqgaL69M/438dXuo31b4zKP+DjX15EW/dJ10l8+TU+/p6qxzaMM4+02UiOvj12sXKV+dqL6xUy0/Yz8bSa0HWswqPvZK6Z8V67R3evzMLxJpAybw51/Bu88+LneOGzu+jfu4v+Z1cxeCO+4fWNfSi70UmPb/0B+OBNPE2755/EhYeP0wT4/T7u3M8afwm/Iz+UL8/jzluUMJ/C2x8Av7GST/a8uvcZjnW7dQzt6xifvfUO/tG9i373EX576wcAlFD0l8AkYsgwL0x2MRCfOsfArvkJ5PvHGJx/Hs+ejmmdfgV/uvcmnqZPkiE4EsRv8Mcbs/j5T7WR5/HC3Of4u3qqAPDdI+Dll3BBH85+nj6D1v1H+I7Kf/oq3nz4Jb7K1glln+MYin8T8yON8ZlX38ZPti+ivX0O7716Cvj6Fv7RjeQpVPPjjuEJYB5GArEe495PbzKr3BgqmBfT6Ut4ATfjbwzjgJGhv1pPhzdtGo5QNcu2/pYxzqfNr7/En19+Jnr6iA89+9ws7nxJ307AV18M8cJz5+Ijjg91gZzDWXXoFM7N/QV/HevwKtOm1adxcnwf79BQTQ3NUrs214tIH7/pcV/XN8ot/xjmmS5ld0mvRg9VX1NPCQWxNNsztWxMo1aMT+H1j+6ir754fsDHX5zDr5IvDzppzDF0Xrs/4OO3buLe/ZtYjJ+g85wzdaif5tO2se/kZfb/iNsBJJAIRuuD6LG/d20YP+rb5TQ0cX/TU9A/xQt3Xo4vrPyF+fR1bftJQCUEsm0Oe/RQw6b5+LshLvxYP9rEx86eA+7s4zG+wV8fPo9no+xgnPgX/EbfPDS0ejd9Cjr74ycx+C5KPsYJY9q0eY2V4/0hfvKuZqjjA2iuydBxm4Zr9Nh/FYjj2b93E3iDYuLHvBhG9LSghoifXQVu3MJX1J4zljaP/gcvOU07Y0w16enjuTR2+uTxxtB17Z7C6+9exQUt5AUX5308m6mj/bM/XbzsGkfd81zOf9RmCs6neQRcxXtxpj/zzPO4cOcxHn//2CovsKC+Geib43WqRGJHb32CZ9/NnPH9J/jtjVn87t5T6unjzv1vce/Fi3g/qfYk/v79K0pNLSlybahvjVv47utH+PPcM3g7nRGJa9McSDxnoidPk32XwTGVTZKjMURU8bnxJb66/hSepm8685v9/FUg4wdo/idm/tphmSeITuMn5ylB/yVS0Lv3iorllsvu17Cvn7PnmC+gxLix8QM+3gZ+/pFRNLHN6Kmn7NrNcfbyx8HL6zz/SgE8gfg761Xzp8/gF3reITlBfxvpG5sOGJOdatLTGOsm57k2TuHZF4bY2h7iF8+VKbJRAId4pOdMXOZCLXNyjJ09T8Oy/ASg+wnR7KAPcwezZCgYDzHu3cXKP+mJUw+nHHZzT4amHyXbX9/CnRdexdPqaYoZOpeYONRhJ/PDcNatc7z08aN/1p9A4nHgH+O5gcdffo57c2dwJlPOdVWN8cy3GzSmVRd4esbjW+/g/bmbeFuPZ8n2eWM+Qo2V9cWYnnfm7Czu/TN/99O3MO6bk6vpOdaWekszi3PxKOi7f36L1tlTVpWx7WR4jZWjkZATu8rxtG80oaz0cjN+RK+wf42P4cc8mmf4Fv9QM88xHbJN14SKUzREffr6p3iTkjNnN+OH8tsBOxdjauMNYEXpA2ffygDjjKHPtRu57OBs9sWcrKdyHQsXr/zlbFqqvH38QxiaHLpwM3X05Zvov3sVr714EW0qVWO/6JudxoJJeXwsPTHaOvPq7/E7NUmqj9C3USQCHZX8gL/f+Ra4fxXtT6kkFn7+6GY00acqRWXqVa02Q5/0jfBG/Lhulqs3PWaBuR09YuuSX3xwN56E/QGPHr6En1/XR474eZwczw+xdeEifkMuG/H51bU/YPHCxbQjNIQBfeuZbAFiQELbsMoZ5mrM/yke0aTtG7HppM2n8N61z7EYDz2VWPfpU6zdp83rh17Bp56mW9kYm7GltzLkB0hYnBL/eGPIXrv4Bq37V7F44ZEaDjs5q6TB1FF9PQecfsXBK+36OLYOJ6rMtEz/jp5W9+rFdGNdCzMmIWfGdbaYviX+ePb36dMLW7PkQAX/g+JI32JvAe8d+ZV4CZ8aD3vHuEIMqTsTjeOEeGV9Lmvm+J9AyjxKjtOrQP1zEVRYj5DzmVf/HaCx9pEmQr/BO28gmsBN+ndcG2FwPK7eHqYdvxjXGcPD9Op4zgk4gYQi5By/RThSPMZh47AOHJGj+gd5h227Kef5xMenTlP6Oz4/J6pIRo9D8nd0AsLx6AxDsHAS4zgxRTISJZG/oxMQjkdnGIKFkxrHsU6ihhAo8UEICIGjE/iXf/03LyNP+Fb0shZXorcvk7BbxYeTUFc4noQoAk2LY5W3p/X/Q7KTcY1IL4TAVBKQBDKVYZdOC4HxEJAEMh6OYkUITCWBmhPIHlZmVrDHoN9bmcHMTPzfSr4WHb+0OUzOLq6fb2u4eSmxb9rhypOGAtow+2wiKuuDeTxhbMXClxfVM+I0cwlRSLjygOAF5IoZxxkzkAH56HKlpgQyxOYluugWse3yCgBd4IvogX66dzQaYKO/CIvrcBPrxsl8faat4SaurLXRU/Z7aK9diS58rpzxs9bivRUs9jcwiPuAxTgZe/RhdnU/Zkt8RxgNNtDpLmEBFXkpAN2YI9nax+qspsKV6+PyqQjQtZzEka719TgJh8+npgQyi9V9uth66DKM1AW+tRAfncXl5Q76D/XTxhCbV3bQ7naSs/n6BW115tFSFhaw1D3Ag0FsjitPWgtkY2ELo/1VRPdrC/OdPhJEFfuwd2MHy9eId0Vew4foJ20ZXLhyo4psxgQGD3DQnovjOIu5tnEtBg6ppgRSlcoQuzsHaM/FX217N7DWvo5r85ydTH1XtdnLWMYOdlVO2sPt7S6W1P3DlLtshFQ23MXOQRsKEdc3zl/1DbiMy8mTg6Nikc2DNbTiYYw5FARX7jA/zUXDh3105qOvMuLQmje/LMMm04gEMty8gjVsQH1BYg8ri0AveTrJA7br549HJbNY/XAZOy0aSq1jfrCF6HmHK+fs1F+u5jNaa2j3DteH4e4O2tf1kwzXH4YLfXt29DBqgOWdVjTU5Mo581LeSALBJxC6OVo7yxjEj+rDzXX0N67FN3ueebZ+vkZcMtzEpSvAh2r+4EPgSjz5x5Wzhuo/EM1nDDC/PhPdvJX6sIcba+3o6auoK5xNaxhlDDW58qI25FjjCASdQPLJIBqaHKy11NuT1toBaFs/Nufr8/Ggb10sX07GnZeXgZ3dIbhy3lIoR9Kbt0ofyhKy7l0Vm/oc+fQjMDvXxkEyAQcMHhjDdT8TtdUKN4HsraBFb0mSSUJipCf4ojcHg40OOhsD7NO0v7M+z1UFbWcX0bRsOmfClfOW6jtCCTN95XeYPtA5lEeLJj+i/nFcbB/oaSayx5XXRyvgllvz6PQfJtfiw34HxpRIwI4D9Apv7H/9e3c9bfZGXXRHvaR2ut/rYkTumf91NgZJTdoYbHRGuqy8fmpbG7HO6RpemG0b5fq84/r04Wj2QbMg/8xyJH3IMOh1R+mxbK8ydVmbdlucD2Z5tqWTvl81jnxMjoeUj7/akxnaGHeKa9rioXH3f1z2hOO4SNZrp2lxrOJvuEOYemMurQsBIeBBQBKIBySpIgSEgJuAJBA3FykVAkLAg4AkEA9IUkUICAE3gRl6y0E/jky/eD7OT3dzUioEhEATCPgqCs7cv39/7G9hzp8/r1Z4NgFUyD5WmQ0PuR/T7lvT4ljF34kMYehJRv6EgBA4+QQmkkBoOCR/QkAInHwCE0kg8gRy8i8c6aEQIAITSSA+TyBlEm5qLYUllUfL7m35Q7KhF9JRZ4pt+kn08e0GKtG3t5LIMqbrYvx8ZXk5bdp8LXU4dS/l+dL6pEQuMX+C3IEGATYWRp0QNyeSQEqfQDwk3HjJvRjjhCQNi9sNTaKPtFG2aemEmrTuYdFIqMW+UqJ0S0YyNjn5RE4CUem2cL6FeCvU6JPH/VCjd4VNT+THtekJpHCJjZJwW0qW0pOE222SEyxYFBpJ7u3HnUklDftxibrxk65GS9t3SN9vIVrBu0oX9MztpIbaSKT4SNJw0elD0u5wU0n3XbMt1Lu3dxvbJOYTKz8ubI0inZThbqmvLC8wNrGFUdwOkMonLswyfDnf6iUWZuuHuB9C6UgtTyCVJdyyknuTlDQ0I5NtNzCJPuKIREvTdByoJieYSgEU2tRNmPKJuizz6WUnc8607la+HwICNZEE4jMHUoUBidmkknuTljRMPbPaDVSir4PbuKTnivQ8Q0VfsxKQTpsxFjVHZMknpryyW0V2snVlv5kEJpJASudAKrGyJffKFLToAjclENmmOIm+5AS7XQQq0XfQn49lGY2fvqjgq4uX02bMJZojMuQTE175jSI7+dpS0kQCE0kgZU8gVSTc7IQRPWpPUtJQB9FuV5eG9UkcO5YsYzU1b1fy8LOZyidyRPzscGdPV3mV+yE0MhNJIKVPIN4SblnJvclLGkYByrYb/dCV+ZpUS/fVGtCFJbTXbsS/7GfMY1hSh6nMoOUrJwHpZTNty7Jp7jB2zCqyHRPwvh/CI1bPW5jZVVxvz6A1sxYR6fYwUm9gojclS6P45wniydLoWDG8vdvRz9QtzqQ/V5fopbpOXdhC73bGB/2WwdEuPbr31E9tRsbI9lbBWyNXk+MvW8BW77b6txbKNnGkPixwvqZ8wfLyt7mveTk7xthx1p3yQvZ+CJ/LRBbT/ej//he+q/nCR1Sfh1UWNdXnpbRcRqBpcazi70SGMGVzIGXA5bgQEALNIDCRBFI6B9IMNuKlEBACJQQmkkDkCaSEuhwWAieEwEQSiDyBnJCrQ7ohBEoIzNCPyNATA9304/4saVsOCwEhECgB35cg8sNSgQaQ3KoyGx5wN6betabFsYq/ExnCTP0VIwCEwJQQkAQyJYGWbgqBSRCQBDIJqmJTCEwJgdoSiI+Em1lHr1SnuPiUp+tWdCTzkntqaXq8FF5LI5pliRyfklKk80lWUf93CZtDbbu+T5OF2WezH7pvOS8ZyUHTJsfdbIurr9uj46wPutKUf5oMTbahY6kngfhIuHESekw53TBuib4hNi/RTb+IdJUMaHUcrqy10RuRHGAP7bUrKiFEy9UjiUBSVRsNNtDpLkVKXyiWCTzuYLN9Zvpm+1dRupCLGROPpC06zwKfHJENTYBjq48H/FlPAlESbnOWpOEDkjQ0/pRKU7JUfQHXNvq4vQdw5erG39Kru8zl5noFbw9dw77atCQND5D1gepEkoYL1LCSCWxlbdS4z/cZQFnfYsnBazEykkPcX51l+YKJGRePCEsqPVkjpvCbZtiG7/iEVNnLOu4j4aY0EnZ2EY0SouXj/YdDcOV2mx7LzWcvYxk72FUN7OH2dhdLOv9oY+qbYRmX9arbwCQNtZvRp9Fnj75RDFxyiBxfLmZcfeVTqfSk3YNp3ePYNoFHPU8gPmRouX17DS0153AFD9qd6Cyu3LCZlegzDhmbs1j9cBk7LRrerGN+EEsIGDWaIGmo3bX7XN43Os8pOejBV7epPtn65dKTlh3ZaSSBcBMIyVps6bmIfSzhIAHMlVMFmheYJklDZ59L5RojlJzkYBHfJAjGhqt+ExTdjC7I5iEJ1JJA1GOvMeEweHCA9pweJ7h6MkT0xJ2tY5d7Jw9KNLs7QDLHQnMmwE40nlEONOUGcPW5rG/UQYpBuRxiytcvZro+sLtzAE560hXhaS7zYxsmoVoSCDwk3OjGSF5n0Vj6IJqj4MrpV9Ba9FZlf7Xo52WSKKigZeZY0iRG8wmUX9KEZbULRiYwsX5MG0yfi/sW+8ZIDlr9NLhzMXPX1xPX0RPkYKODQnW4Y8IVbDMe90Owvo8m8EcL9Mr+el2MgPi/bi+u3ht10R0le0adpMpoNDLP1eVmmbbb2RgYbti26YB1jjYUHRjRz71l/8z6tu1szfHsl3E0/cn22TqW9CXDoNd1xMDmkpxawMtsy6yvKQw2OqPj4KXbC+2zLI7kr8nQde0dZ598/NX+yGK6YFO7LKYLODSVXKuyOK2S4QlVruJvPUOYCXVczAoBIXC8BCSBHC9vaU0InCgCkkBOVDilM0LgeAlIAjle3tKaEDhRBJSk4YnqkXRGCAiBIxPwlTR8wrdiFY+qzOJWsTttdYXjyYh40+JI/vr+yRDGl5TUEwJCIEdAEkgOiRQIASHgS0ASiC8pqScEhECOQM0JJC8zqD1UaywS+UAtI7iCPV0hljY0pfKKZeHybZltmHa4cqPpYDbNPmv5QdP/VILRZgfwEo2mzWQ9UkF9WoeUtKOdSAjluSeHZCMh4GaeHA52o6YEwsgMGpiKpQUjSUJTKo9umnFIGnJSh4Zr4WwycoKl7JIeOCQaC+X1HPUpsSxu0/INkARkD4ux/ml5jBM3pn2jkHnYcGpKIHq1pkNmkOGVSAuq43mpPF7er6AtTvaPK2d8q6tYKVklkgSp7GPWH5tdfJSTaOTk9bj6jDQiUMA96+C073PMG8ClpgRSkUxWWrBUKs+Q9+Oa4mT/uHLOTo3lrmX7JPto/WXZmQcdEo2F8npMfZc0otmMbBcTKGRefGrtRxuRQCxpQfXIDPQSAeU8Q1veL388KuFk/7hyzk6N5aycYOqTzS4tVyLJnQ0MlCr9AMs7LeSmL4zqRfWd0ojmubJ9Ygk0IIGQeE87ETwuUwqjuZAjSRp6ygGGckW45ART32x2abnSi8QoEV8yVeytWunOwhZbn5NGTE+WrZNKIPgEYieMaGjCSeV5J48CSUMfOcAwLwYtJ2iqqK2jv3Et/k0bP6+ryutR/XJpRL+2p7VWVeYhcQo8gWSlBfXEnEMqj5H342C75g9I0pAr5+zUWa5e1+pxhyk/qJzKsrM9tc41JRoZeT22PiONaLcme4UEGOaF54RyUEuTjfPTXxItI7E3yuyT5J5LIy921pTKsyThYqlEW0YvY7tARs6yVdD+OJm5bPlwNH21XHWysxmY55qszHKTv1lu1h8x0ohRn+w2Xf086WVV42gyr4ONj7/aL5E0DCWTO/xo2iIsRxekCM2Tpqxy3QU+hJHrTwgIgZAJSAIJOTrimxAInIAkkMADJO4JgZAJSAIJOTrimxAInIBIGgYeIHFPCNRBwFepUCQN64iOZ5tVZsM9TUq1Ggg0LY7kr++fDGF8SUk9ISAEcgQkgeSQSIEQEAK+BCSB+JKSekJACOQI1JZAfCTczDp6yQf1wKc8leLTfc5L66n1HbFsopY0NMsSmb4ZkgPkJQB1C3V+EhPdhyJG2ke+nzbfPMfouG7rKHa0L/JZzjxURvUkEB8JN0auj/Q3F/tax6IHLEZan3Qhj0PSsFgO0CXpF0Boiee24QfDyKgBtp9lscm0xdlpsfEwvZBtRaCMecCY6kkgHhJunFwfVz5WSUMjYIkcICfpZ9StZzMv78gxKvIv6WdhbPJtZW1qO3w8smfIvhJras8hEmKYxVz7AA8GzeBSSwLxkXBzLasnuT6u3MZ9BElD05D6ZljGZS2x4ZD0M6vXsu2Qd/RjZHhr9LMwNo62DCsgQer1vsErOegRj6Tu9G0UMg8cRy0JxIsJJ9fHlRtGjyZpmBqy5ADpm7mKBGBqZoJbpIjukHf0YGQ6ZfXTPGBtM20ZdTg7fvEwDMlmYwiEm0CU6l4kHDQa7WMJBwnUIhk/mgs5kqRh0kpGDrBA0i855Zg3bLU2u/EiRnbNTD/tg8leUVtRJbcd73gkLclGkwjUkkDUI7YxyBs8OACpgfF/ebm+qK5dXuViLZMuLL9heG+P50g0LODkHVMfbEZpebSV7ac7NsDuzgGK2sraIetV4pH1a5r23cyL7odw6NSSQOAh4UYXX/IK0ZDr48rp7UxrrY1eIhRcDNk1T5AmsbwcoNWuKQFY3MwEj/LyjpavBru8M/l+umPDtxXZdNipGI+8b1NU4nE/BEtDS5ON89NHEs2Ux0sl3Gz5O7OOKdfnKjfLcERJQyXRZzYYwzHbsCT9xgnPsOXDUVc35R2pzPQ17YrN16efaWx0S6NRti2XHbN9dzxSeyd9yyeOFq80YLWg8fFXOyaShsGm9uZJ4QWMslbXmriYznc1bj1DmFrDKY0LASEwLgKSQMZFUuwIgSkkIAlkCoMuXRYC4yIgCWRcJMWOEJhCAiJpOIVBly4LgTICvpOoImlYRrLG402bva8RVdBNNy2OImkY9OUkzgmBk0NA5kBOTiylJ0Lg2AlIAjl25NKgEDg5BGpLIKYsYbLmJcPVrCOShhk48S7HiNYGJZKMJjzDjHmujoFaRxPLPCbnK0lHXnbPPEdLHVIzpn3GBcOb6d40WelYNIKI/jft4/ws/bf0g41Rp7MxGqhGB6ONTme0Ee2kbvS6IyR1jDUcTDmtz0jXbZBNjKIlBdF2tB6jO+rpFsgH6H2y7/CB6lI9ZcjwQduY8GcpR4bFaES+6v5H62Jya3d8YmD0n+XLcWR9mzC0AM2XxtE3FsfUt1J/DT/qeQIplM2L8i4ny8eV8xJ6eiVpD91sSu/Mo6XKFrDUdcvIaYk+hChpaGmUtDDf6ePhkL76b2O7s4FrC1GHSRtkfzWzPNwjBnS27j/PF4CLI+dbNgayD5E0rHgR+Ei4uZbbi6RhAejhLnYO2iBZFeKLRGPTfY5PDLwkCmcvYxk72KXEhT3c3u5iKU5cScuGb0mZbCQEvGKR1A5ro54nEB8GnCwfV27Y9JPQm8Xqh8vYac1gZmYd84Mt5K/7HbSvr0Zit0FKGkadVnMQrTW0e2kfOriNS3ou45ATEH4ShcUcXb4ZoZLNhhMIN4GIpKH3paWGF6MB5tdnoHPFQX8eH45IEnKAjf5iUu5tVIkmtXNPE5QQLMnI4SYuXUHc1ofAlUvYVE8jUUsu3/x9kJqhE6glgVSXcONk+ezy3MVdQL/5kobZzs3i8nIHepjXWb6c/EyALjfPKIuBr0RhGceozdQ30wfZjunMtXFQSeIzHHK1JBC3bJ4NRT366q9TQ5aPK58+ScNIczR95RdppCpZxoUltNduYE8hNcpNxIUyev4Sha65KvLBihMYH0x/pnm7MBaBgzHeyIxt0+c1kFvCzX5VatYxVd5c5WaZW0LPtk2dtc6xGzBeCadYzPq516JptbFtVeVo+USvUWNpx/T1ts3A7E9aR4HJ9d+qm5GMtI4ZHM1yy7exEWqGoapxtGJRQxd9/NVuiaRhwAm+aYuwAkZZq2tNi2MVf+sZwtQaTmlcCAiBcRGQBDIukmJHCEwhAUkgUxh06bIQGBcBSSDjIil2hMAUEhBJwykMunRZCJQREEnDMkINOF5lNrwB3ZlaF5sWR/LX90+GML6kpJ4QEAI5ApJAckikQAgIAV8CkkB8SUk9ISAEcgRqSyA+Em5mHb0shnrgU56uEdF93sNKLM2nS9R6jXjJu5biM8tsST86n5b+6//sVafa5nF/Ho5F5KV5rsWLkUM02WheZMm0Y8bpuFk0uT2ToRWLwDtVTwIZbmK9v4FBstx83VoCrpjtrWAxqdMDFleixWFMOV3ci+hhlNjUS9iH2LxEN/0its1gDDdxZa2NnqrfQ3vtivIhWn5Oy+Dj/wYb6HSXYq2Qblyfju0jK/Jlmj+WbYZFJARUwpeNwR5WFrdpOYZi0MMiVLJgeNEiRmecjgXACWmEjUX4/asngXjI6SmVpmRJ+gKubfRxey9S20qXqqflvOTeFEoaevBlZfSK5BAd0oVcnMK/9APy0CdeAblrulJLAvGRcHMtE9daFwc7u4g0a6Jl4lRu/3ksH/eS4qMnpWVc1nKiB2toZYY8drs17hmygT58uTpU7pRDZHhxcaqRROOa5mLRhI7UkkC8wHDShVy5YVQkDQ0Yh9h0yyEy0oUe8TiEC3JKQwiEm0BE0tD7Ehq3bKBTDrFAupBU36M5o30s4cDbb6nYfAK1JJAyOb08Vlu6MD1ul9NEqqXXmVbMbZVJ8bkk/XJGgipIZQN9+HJ1qDydY0ptlvGKUNjxCApPwM5wsQjY5cS1WhKISBom/I+0oV6rJu9NjXkfH4k8rg4jh6gu8szcU0660JCePFLHpu1kLhZN4KClycb56SOJZsrdpRJuvOSeoZRnSRHqcsteRnIv6pttm8qsc7Sh6EBO0i9b/zgk+qpyNH1y981m4K4TSxrm5BB5XqYdE2PEXf5fNY7p/VAPOx9/tWciaRhwlm/aIqyAUdbqWtPiWMXfeoYwtYZTGhcCQmBcBCSBjIuk2BECU0hAEsgUBl26LC0zKbwAAAM6SURBVATGRUASyLhIih0hMIUERNJwCoMuXRYCZQRE0rCMUAOOV5kNb0B3ptbFpsWR/PX9kyGMLympJwSEQI6AJJAcEikQAkLAl4AkEF9SUk8ICIEcgZoTSF5m0PTQlHlLlnwA4KT19Ll0XpnknmkjlSkk1bMwpQt137KfJiNTCs8sN9mZ5xfXsWPD8+IlDU37pm+mD7IdEWgqq5oSCCMzaF5NnFQeJ62nzyV5OFO7kLHTKOlC3bfMJ93UThlHps/W6Wwdd2xYXowd1jfLCdlRBETSsOqFUCAzGJtSKk0OSUN12CGtF502xOaVHbS7ndShhS2M9lcRiYq1MN/pIydgRsLAN3awfG2BNBPRT+ynZkLcYmUcPfrM8y2PDbFIeDFtsb6FCLJun0TScPwRcC0fV9KFjLSe8oCWk7ev49o8448h+2fVUN8ADZEutBw3d4zl/FbxLnYO2pjTsozxMZaveS63neWl63F8wfimz5vyT5E0nMQFwErlMdJ6NHexCPS2FpzeqDF8aw3t3lassJ5WI7Gc9vX4KYW+DTqpovnyTgvcHEJqof4tl4xjUZ/B8i3vi8Urrl7Ulsu38lakRhMI1DQH4ofGKZXHSOuVKYhFY/gB5tdnMglhDzfW2ljSecd6JE8Vufw8rqcW3bwuJTa+z5GfTr6lXcjwiutzbXG+lTYjFRpBIOgEkhJMpfLc0np72N05wMFaS/3wU2st2jbfxES28gmhLPGkPoS5VX6D5vuc70nKN3/MLinmZbdV7ptte1r3RNJwApGniy959WdI5bnG7u25Bazua2HfEQYbHXQ2BthfnY1e+SZjkOxYnPaB5eR3G+JXxEl9+ra1j0+gq4c3ubeCFv04VjJJHJmy2DHzD1Ydg2+xM2W8DL6Mb8X2p/SoSBpqgbPo018SzZbYG43sfU4qzyx3yb8NNjojTt7PLB/1ukFIF9r00r0yjhaHjIyjeSztsx/fyAO7riqrwMtsHxnf0h5Ox1ZZHImCxatmXUgff3XkRNIw4C+9pi3CChhlra41LY5V/G3IHEit8ZfGhYAQYAhIAmHASLEQEALlBCSBlDOSGkJACDAEJIEwYKRYCAiBcgL/D1+Ul/MouvZZAAAAAElFTkSuQmCC" data-filename="image.png" style="width: 272px;"><br></p><p>Get information about all files</p><blockquote>select * from sys.master_files</blockquote><p>or files of one database</p><blockquote>select * from dbo.sysfiles</blockquote><p>After all check (if the drive have enough space to add onto a file) use the below command:</p><blockquote>USE master;<br>GO<br>ALTER DATABASE DB01 <br>MODIFY FILE<br> (NAME = DB01_log,<br> SIZE = 300MB);<br>GO</blockquote><p><br></p><p><br></p><p><br></p>
<footer>
By <a href="http://docsroot.devcovery.com/Listing/ViewBy?author=1" target="_blank">hu****hd@gmail.com</a> at 1/9/2019 4:00:46 AM. <a href="https://docsroot.github.io/Evolutions-and-mitigations-2019---from-prod-views.html" target="_blank">View online</a>. Built with ♥ by <a href="http://docsroot.devcovery.com" target="_blank">docsroot</a>
</footer>
</body>
</html>