<![CDATA[
<p>MSSQL 2008 Express 는 무료 버전이라 사용하기가 편하긴 하지만</p><p> </p><p>스케쥴러 백업이 되지 않습니다.</p><p> </p><p>하지만 배치를 통해 스케쥴러 돌리는것 처럼 자동 백업을 할 수 있다고 하는군요.</p><p> </p><p>일단 백업을 받을수 있는 .sql 파일을 아래 내용으로 생성하고 저장합니다.</p><p> </p><pre class="lang-sql prettyprint prettyprinted"><code><span class="kwd">BACKUP</span><span class="pln"> </span><span class="kwd">DATABASE</span><span class="pln"> MyDataBase1 </span><span class="kwd">TO</span><span class="pln"> </span><span class="kwd">DISK</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> N</span><span class="str">'D:\DBbackups\MyDataBase1.bak'</span><span class="pln"> </span><span class="kwd">WITH</span><span class="pln"> NOFORMAT</span><span class="pun">,</span><span class="pln"> INIT</span><span class="pun">,</span><span class="pln"> NAME </span><span class="pun">=</span><span class="pln"> N</span><span class="str">'MyDataBase1 Backup'</span><span class="pun">,</span><span class="pln"> SKIP</span><span class="pun">,</span><span class="pln"> NOREWIND</span><span class="pun">,</span><span class="pln"> NOUNLOAD</span><span class="pun">,</span><span class="pln"> STATS </span><span class="pun">=</span><span class="pln"> </span><span class="lit">10</span><span class="pln"></span><span class="kwd">BACKUP</span><span class="pln"> </span><span class="kwd">DATABASE</span><span class="pln"> MyDataBase2 </span><span class="kwd">TO</span><span class="pln"> </span><span class="kwd">DISK</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> N</span><span class="str">'D:\DBbackups\MyDataBase2.bak'</span><span class="pln"> </span><span class="kwd">WITH</span><span class="pln"> NOFORMAT</span><span class="pun">,</span><span class="pln"> INIT</span><span class="pun">,</span><span class="pln"> NAME </span><span class="pun">=</span><span class="pln"> N</span><span class="str">'MyDataBase2 Backup'</span><span class="pun">,</span><span class="pln"> SKIP</span><span class="pun">,</span><span class="pln"> NOREWIND</span><span class="pun">,</span><span class="pln"> NOUNLOAD</span><span class="pun">,</span><span class="pln"> STATS </span><span class="pun">=</span><span class="pln"> </span><span class="lit">10</span><span class="pln">GO</span></code></pre><p>그리고 위 .sql 파일을 돌릴 수 있는 .bat 파일을 아래와 같이 생성합니다.</p><pre class="lang-sql prettyprint prettyprinted"><code><span class="str">"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE"</span><span class="pln"> </span><span class="pun">-</span><span class="pln">S </span><span class="pun">(</span><span class="pln">local</span><span class="pun">)\</span><span class="pln">SQLExpress </span><span class="pun">-</span><span class="pln">i D</span><span class="pun">:\</span><span class="pln">dbbackups</span><span class="pun">\</span><span class="pln">SQLExpressBackups</span><span class="pun">.</span><span class="pln">sql</span></code></pre><pre class="lang-sql prettyprint prettyprinted"><code><span class="pln">다음 관리도구의 [예약 작업]에서 만든 .bat 파일을 걸어놓으시면 됩니다.</span></code></pre><pre class="lang-sql prettyprint prettyprinted"><code><span class="pln">그러면 Express 도 예약 백업을 돌리실 수 있습니다.</span></code></pre><pre class="lang-sql prettyprint prettyprinted"><code><span class="pln"></span></code> </pre><pre class="lang-sql prettyprint prettyprinted"><code><span class="pln">참고하세요.</span></code></pre>
<!-- -->
]]>
카페 게시글
[DB]강좌게시판
MSSQL 2008 Express 데이터베이스 스케쥴러 백업
보노보노
추천 0
조회 925
15.05.06 13:38
댓글 0
다음검색
