首页 > 代码库 > IP 获取 和 数据库备份

IP 获取 和 数据库备份

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Ip获取
string strHostName = System.Net.Dns.GetHostName();
string clientIPAddress =
System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString();
 
 
 
数据库备份
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