infosqldmo.cs

使用SQL Server Agent 自动对SQLServer数据库进行自动备份

using System;
using System.Collections.Generic;
using System.Text;

namespace dbMaintain.Info
{
   public class informationLayer
    {
        #region " Declarations "
        string _strServerName;
        string _strLoginName;
        string _strPwd;
        string _strDatabaseName;
        string _ErrorMessageDataLayer;
        int _intStartDate;
        int _intStartTime;

        #endregion

        #region " Functions "
        public string strServerName
        {
            get { return _strServerName; }
            set { _strServerName = value; }
        }
        public string strLoginName
        {
            get { return _strLoginName; }
            set { _strLoginName = value; }
        }
        public string strPwd
        {
            get { return _strPwd; }
            set { _strPwd = value; }
        }
       public string strDatabaseName
       {
           get { return _strDatabaseName; }
           set { _strDatabaseName = value; }
       }
       public string ErrorMessageDataLayer
       {
           get { return _ErrorMessageDataLayer; }
           set { _ErrorMessageDataLayer = (value == null ? value : value.Remove((value.IndexOf(".\r", 1) == -1 ? value.Length - 1 : value.IndexOf(".\r", 1))).Replace("'", "`")); }
       }

       public int intStartDate
       {
           get { return _intStartDate; }
           set { _intStartDate = value; }
       }

       public int intStartTime
       {
           get { return _intStartTime; }
           set { _intStartTime = value; }
       }

        #endregion

   }
}