defaultvalues.backupsettings

sqlserver异地备份原代码,经测试可用,sqlserver异地备份原代码,经测试可用

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
  <DefaultValues>
    <Server>SHABDAR\SQLEXPRESS</Server>
    <Database>SMS</Database>
    <UserName>safdar</UserName>
    <Password>ghata</Password>
    <chkData>true</chkData>
    <chkStructure>true</chkStructure>
    <NoOfRows>TOP 100 PERCENT *</NoOfRows>
  </DefaultValues>
  <table>
    <TableName>Activities</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>Attendence</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>Countries</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>Donations</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>ExamAttendance</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>Exams</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>Fees</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>FeesDetails</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>Grades</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>GradesDetails</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>Holidays</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>Lectures</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>OtherIncome</TableName>
    <Select>true</Select>
    <TotalRows>TOP  99  *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>PaymentTypes</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>Students</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition>StudentID &gt; 120 and StudentID &lt;200</Condition>
  </table>
  <table>
    <TableName>SubjectDetails</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>Subjects</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>TeacherCategories</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>Teachers</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <table>
    <TableName>Terms</TableName>
    <Select>true</Select>
    <TotalRows>TOP 100 PERCENT *</TotalRows>
    <Condition />
  </table>
  <user>
    <UserName>guest</UserName>
    <Select>false</Select>
  </user>
  <user>
    <UserName>INFORMATION_SCHEMA</UserName>
    <Select>false</Select>
  </user>
  <user>
    <UserName>safdar</UserName>
    <Select>false</Select>
  </user>
  <user>
    <UserName>sys</UserName>
    <Select>false</Select>
  </user>
</NewDataSet>