|
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 |