xixilive的博客

责人之心，恕己之心——Mickey!

日志

关于我

xixilive

你想

文章分类

SQLExpress 2005 自动备份

2008-09-19 12:19:50| 分类： .NET | 标签： |举报 |字号大中小订阅

下载LOFTER 我的照片书 |

2-3步实现SQL Express 2005 数据库自动备份
第一步：创建存储过程(master库)
方式一：进入cmd，运行命令 sqlcmd -S 数据库服务器名 -E -i 存储过程的sql文件(expressmaint.sql)；
方式二：如果装有Manage Studio工具，则可以直接进入数据库创建存储过程；

上文提到的expressmaint.sql请参看我的相关日志内容：
SQLExpress 2005 自动备份的存储过程(I)
SQLExpress 2005 自动备份的存储过程(II)

第二步：创建批处理文件
新建文本文件，改名为BackUp.bat，
------------------------------------------------------
@echo off
ExpressMaint -S MAIDI\SQLEXPRESS -D ALL_USER -T DB -B D:\WEB_DATA_BACKUPS\DATA -R D:\WEB_DATA_BACKUPS\Reports -RU WEEKS -RV 1 -BU WEEKS -BV 1 -V -C
-------------------------------------------------------
在 BackUp.bat文件中键入以上代码，保存在合适的位置。
（注意：备份文件和备份报告文件的存储目录应该赋予SQLServer相关用户组的写权限）

上文提到的ExpressMaint命令请参看：
http://www.codeplex.com/ExpressMaint

第三步：创建系统任务计划
创建一个计划任务，定时运行上述批处理文件。

附：ExpressMaint命令参数表

Switch	Argument	Required	Description
-?	N	N	Displays help for the ExpressMaint utility
-S	Y	Y	The SQL Server for ExpressMaint to connect to
-D	Y	Y	The target database for the maintenance operation. Valid values are a single database name, ALL_USER which will process all user databases, ALL_SYSTEM which will process all system databases and ALL which will process all databases
-T	Y	Y	The type of maintenance operation to be performed. Valid values are DB - Full Database Backup DIF - Differential Database Backup LOG - Log Backup CHECKDB - Database Integrity Check REINDEX - Rebuild all indexes REORG - Reorganize all indexes STATS - Update all statistics using default sampling STATSFULL - update all statics with fullscan
-B	Y	N	The base folder to write the backups to. Sub folders will be created for each database
-V	N	N	Indicates whether to verify the backup file
-BU	Y	N	The unit of measure for the -BV argument. Valid values are minutes, hours, days, weeks. The combination of these two arguments determines for how long old backup files are kept. Required if -B argument is specified.
-BV	Y	N	The time period of old backups to keep. Required if -B argument is specified.
-R	Y	N	The folder where maintenance reports are written to
-RU	Y	N	The unit of measure for the -RV argument. Valid values are minutes, hours, days, weeks. The combination of these two parameters determines for how long old reports are kept. Required if -R argument is specified.
-RV	Y	N	The time period or number of copies of old reports to keep. Required if -R argument is specified.
-A	N	N	Indicates whether to check the archive bit on a backup file before deleting it. This is a safety check to prevent deletion of files that have not been backed up onto tape.
-DS	N	N	If this switch is specified then the timestamp for backup and report files is appended to the front of the filename (the default is to append to the end of the filename)
-TO	Y	N	This switch allows the setting of a statement timeout specified in minutes (e.g. -TO 10). If not specified, the default is 10 minutes.
-C	N	N	This switch allows multi database maintenance operations (ALL,ALL_USER,ALL_SYSTEM) to continue if an error is encountered with one or more databases

评论这张

转发至微博

阅读(1298)| 评论(0)

历史上的今天

this.p={  m:2,
              b:2,
              loftPermalink:'',
              id:'fks_085065084095083064083082095095081083080068093080095067',
              blogTitle:'SQLExpress 2005 自动备份',
              blogAbstract:'第一步：创建存储过程(master库)；第二步：创建批处理文件；第三步：创建系统任务计划',
              blogTag:'sqlexpress2005,自动备份',
              blogUrl:'blog/static/55179690200881901950497',
              isPublished:1,
              istop:false,
              type:0,
              modifyTime:1316970167669,
              publishTime:1221797990497,
              permalink:'blog/static/55179690200881901950497',
              commentCount:0,
              mainCommentCount:0,
              recommendCount:0,
              bsrk:-100,
              publisherId:0,
              recomBlogHome:false,
              currentRecomBlog:false,
              attachmentsFileIds:[],
              vote:{},
              groupInfo:{},
              friendstatus:'none',
              followstatus:'unFollow',
              pubSucc:'',
              visitorProvince:'',
              visitorCity:'',
              visitorNewUser:false,
              postAddInfo:{},
              mset:'000',
              mcon:'',
              srk:-100,
              remindgoodnightblog:false,
              isBlackVisitor:false,
              isShowYodaoAd:false,
              hostIntro:'你想',
              hmcon:'1',
              selfRecomBlogCount:'0',
              lofter_single:'<iframe width="140" height="560" style="overflow:hidden;" src="http://www.lofter.com/mailEntry.do?blogad=1&blog" frameBorder="0"></iframe>'
            }

{list a as x}
    {if !!x}
    <div class="iblock nbw-fce nbw-f40">
      <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.visitorName}/">
      {if x.visitorName==visitor.userName}
      <img alt="${x.visitorNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.visitorName)}&r=${visitor.imageUpdateTime}"/>
      {else}
      <img alt="${x.visitorNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.visitorName)}"/>
      {/if}
      </a>
      <div class="cwd vname thide">
        {if x.moveFrom=='wap'}
          <a class="noul pnt" target="_blank" href="http://blog.163.com/services/wapblog.html?frompersonalbloghome"><span title="来自网易手机博客" class="iblock wapIcon"> </span></a>
        {elseif x.moveFrom=='iphone'}
          <a class="noul pnt" target="_blank"><span title="来自iPhone客户端" class="iblock iphoneIcon"> </span></a>
        {elseif x.moveFrom=='android'}
          <a class="noul pnt" target="_blank"><span title="来自Android客户端" class="iblock androidIcon"> </span></a>
        {elseif x.moveFrom=='mobile'}
          <a class="noul pnt" target="_blank" href="http://blog.163.com/services/emsblog.html?frompersonalbloghome"><span title="来自网易短信写博" class="iblock wapIcon"> </span></a>
        {/if}
        <a class="fc03 m2a"  target="_blank" hidefocus="true" href="http://blog.163.com/${x.visitorName}/">
          ${fn(x.visitorNickname,8)|escape}
        </a>
      </div>
    </div>
    {/if}
    {/list}

<#--最新日志，群博日志--> <#--推荐日志-->

<p class="fc06">推荐过这篇日志的人：</p>
    <div>
      {list a as x}
      {if !!x}
      <div class="iblock nbw-fce nbw-f40">
        <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.recommenderName}/">
        <img alt="${x.recommenderNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.recommenderName)}"/>
        </a>
        <div class="cwd thide">
          <a class="fc03 m2a" target="_blank" hidefocus="true" href="http://blog.163.com/${x.recommenderName}/">
            ${fn(x.recommenderNickname,6)|escape}
          </a>
        </div>
      </div>
      {/if}
      {/list}
    </div>
    {if !!b&&b.length>0}
    <p  class="fc06">他们还推荐了：</p>
    <ul>
    {list b as y}
      {if !!y}
        <li class="rrb"><span class="iblock">·</span><a class="fc03 m2a" target="_blank" href="http://blog.163.com/${y.recommendBlogPermalink}/?from=blog/static/55179690200881901950497">${y.recommendBlogTitle|escape}</a></li>
      {/if}
    {/list}
    </ul>
    {/if}

<#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇，下一篇--> <#-- 热度 -->

{list a as x}
    {if !!x}
    <div class="hotItem iblock nbw-fce nbw-f40">
      <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.publisherUsername}/">
      {if x.publisherUsername==visitor.userName}
      <img alt="${x.publisherNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.publisherUsername)}&r=${visitor.imageUpdateTime}"/>
      {else}
      <img alt="${x.publisherNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.publisherUsername)}"/>
      {/if}
      </a>
      <div class="cwd vname thide">
        <a class="fc03 m2a"  target="_blank" hidefocus="true" href="http://blog.163.com/${x.publisherUsername}/">
          ${fn(x.publisherNickname,8)|escape}
        </a>
      </div>
      <a class="f-myLikeIcons hottype {if x.type==1} js-liketype{elseif x.type==2} js-reblogtype{elseif x.type==3} js-sharetype{else}{/if}" target="_blank" hidefocus="true" href="http://blog.163.com/${x.publisherUsername}/"> </a>
    </div>
    {/if}
    {/list}

<#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->

页脚

我的照片书 - 手机博客 - 下载LOFTER APP - 订阅此博客

xixilive的博客

导航

日志

SQLExpress 2005 自动备份

历史上的今天

最近读者

热度

评论

页脚