获取本地 IP 和 数据库备份

Ip获取
//本机名
string HostName= System.Net.Dns.GetHostName();
//本机IP
string HostIP= System.Net.Dns.GetHostAddresses(HostName).GetValue(0).ToString(); //IP6 地址

string HostIP= System.Net.Dns.GetHostAddresses(HostName).GetValue(1).ToString();

string HostIP= System.Net.Dns.GetHostAddresses(HostName).GetValue(2).ToString();//IP4 地址

string HostIP= System.Net.Dns.GetHostAddresses(HostName).GetValue(3).ToString(); 

//这个也可以获取IP，未测试

//IPAddress ipAddr = null;
//IPAddress[] arrIP = Dns.GetHostAddresses(Dns.GetHostName());
//foreach (IPAddress ip in arrIP)
//{
// if (System.Net.Sockets.AddressFamily.InterNetwork.Equals(ip.AddressFamily))
// {
// ipAddr = ip;
// }
// else if (System.Net.Sockets.AddressFamily.InterNetworkV6.Equals(ip.AddressFamily))
// {
// ipAddr = ip;
// }
//}

数据库备份 
declare @name varchar(250) set @name = 'F:\Backup\MouldDB_' + convert(varchar(50),getdate(),112)+'.bak' BACKUP DATABASE[MouldDB] TO DISK = @name WITH NOFORMAT, NOINIT, NAME = N'MouldDB-完整数据库备份', SKIP, NOREWIND, NOUNLOAD