<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="login_databack.aspx.cs" Inherits="Web.admin.login_databack" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>无标题页</title>
    <link href="../css/admincss/skin.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
   <div>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td class ="top_bg_left "></td>
    <td  class ="top_bg_center " >
    <table style ="width :100%; height :31"  border="0" cellpadding="0" cellspacing="0" class="left_topbg" id="table2">
      <tr>
      
<!--这里写页标题 -->
        <td style ="height :31px"><div class="titlebt">系统管理</div></td>
      </tr>
    </table>
    </td> 
    <td class ="top_bg_right "></td>
  </tr>
  
  <tr>
    <td style ="background :url(../css/admincss/images/mail_leftbg.gif); vertical-align :middle " >&nbsp;</td>
    <td style ="background-color :#F7F8F9; vertical-align :top " >
 
<!--  一组内容模块开始   --> 
    <table class ="tablezong"   border="0"  cellpadding="0" cellspacing="0" >
      <tr>
        <td style ="height :40px" >
        <table class="tablebiaoti"  border="0" cellpadding="0" cellspacing="0" >
          <tr>
            <td><div class ="biaotileft ">  
                数据库备份还原</div> </td>
          </tr>
        </table>

        </td>
      </tr>
      <tr>
        <td>
          <table class ="table " width="880px" cellpadding="0" cellspacing="0" border="1"  bordercolor="Black" style="border-collapse:collapse;">
  
                <tr>
                    <td class="tabletd_right">
                        数据库备份：</td>
                          <td class ="tabletd_left ">
     <asp:Panel ID="Panel1" runat="server" Visible="False">
   <div >    选择SQL Server数据库版本：<asp:RadioButtonList ID="rbsql" runat="server" 
        RepeatDirection="Horizontal"  AutoPostBack="True" 
        onselectedindexchanged="rbsql_SelectedIndexChanged" >
        <asp:ListItem Value="SQL2000">SQL Server 2000</asp:ListItem>
        <asp:ListItem Value="SQL2005">SQL Server 2005</asp:ListItem>
        <asp:ListItem Value="SQL2008">SQL Server 2008</asp:ListItem>
    </asp:RadioButtonList>
    SQL Server路径：<asp:TextBox ID="tbsqlpath" runat="server" Width="379px" 
           BackColor="Silver" ReadOnly="True"></asp:TextBox>          
     <asp:Button ID="btsqlpath" runat="server" Text="提交" onclick="btsqlpath_Click" />    </div>
    </asp:Panel>
   SQL Server备份路径： 
        <asp:Label ID="lbsqlpath" runat="server"></asp:Label>
        <asp:Button ID="editpath" runat="server" Text="修改" onclick="editpath_Click" />
        <div> <asp:Button ID="backsql" runat="server"  OnClick="backsql_Click" Text="备份数据库" /> </div>
        </td>
                                       </tr>
                                                 <tr>
                                           <td class="tabletd_right">
                                               数据库还原：</td>
                                           <td class ="tabletd_left ">
                                                         
                                                          <table style ="width :100%">
                                                              <tr>
                                                                  <td >
    <asp:RadioButtonList ID="RadioButtonList1" runat="server" 
        ToolTip="先选择备份文件，然后进行还原或删除操作">
    </asp:RadioButtonList>
 </td>
  <td >
    <asp:Button ID="delbackupfile" runat="server" onclick="delbackupfile_Click" 
        Text="删除"  OnClientClick="return confirm('确认要删除备份文件吗？确认后，被删除的文件不可恢复！')" Visible="False" /> 
      </td>
          </tr>
            <tr>
              <td colspan="2" >说明：备份的数据库由年月日时分秒共14位数字组成。</td>
               </tr>
               </table>
               <div>  <asp:Button ID="btrestore" runat="server"  OnClick="btrestore_Click" Text="还原数据库" 
               OnClientClick="return confirm('确实要用这个备份文件替换当前数据库中的数据吗？确认替换后不可恢复！')" Visible="False"/> </div>
              </td>
           </tr>
   </table>
   说明：<br />
   1、还原数据库应选择无人查询或查询较少的的时间段进行。<br />
   2、WEB文件夹和SQL安装在同一服务器上才可以使用备份还原功能，并且需要服务器权限支持。
    </td>
    </tr>
    </table>
<!-- 一组内容模块结束 -->
   
    </td>
    <td  style =" background-image:url(../css/admincss/images/mail_rightbg.gif )" >
    </td>
  </tr>
  <tr>
    <td  class ="buttom_bg_left "></td>
    <td class ="buttom_bg_center " ></td>
    <td  class ="buttom_bg_right " ></td>
  </tr>
</table>
    </div>
    </form>
</body>
</html>
