Configuration Archives - 17 중 17 번째 페이지

sendmail 설정

sendmail.mc 수정

[ Korean White Domain 설정시]

FEATURE(dnsbl, `blackholes.mail-abuse.org', `Rejected - see http://www.mail-abuse.org/rbl/')dnl
FEATURE(dnsbl, `spamlist.or.kr', `Rejected - see http://www.kisarbl.or.kr/')dnl

1 2	FEATURE(dnsbl, `blackholes.mail-abuse.org', `Rejected - see http://www.mail-abuse.org/rbl/')dnl FEATURE(dnsbl, `spamlist.or.kr', `Rejected - see http://www.kisarbl.or.kr/')dnl

[Spam Filtering 해외 블랙 도메인 설정시]

FEATURE(`dnsbl', `relays.ordb.org', `"Rejected due to Open Relay see http://www.ordb.org/lookup/?host=" $&{clientaddr} " for more information"')dnl
FEATURE(`dnsbl', `sbl.spamhaus.org', `"Rejected due to Spamhaus listing see http://www.abuse.net/sbl.phtml?IP=" $&{clientaddr} " for more information"')dnlnl

FEATURE(`dnsbl', `relays.ordb.org', `"Rejected due to Open Relay see http://www.ordb.org/lookup/?host=" $&{clientaddr} " for more information"')dnl

FEATURE(`dnsbl', `sbl.spamhaus.org', `"Rejected due to Spamhaus listing see http://www.abuse.net/sbl.phtml?IP=" $&{clientaddr} " for more information"')dnlnl

[To stop accepting E-mail from unresolvable domains ]

FEATURE(`accept_unresolvable_domains')dnl

1	FEATURE(`accept_unresolvable_domains')dnl

sql server 백업을 하게 하기 위한 스크립트

"C:\Program Files\Microsoft SQL Server90\Tools\Binn\sqlcmd" -S localhost -i e:\Backupbackup.sql

1	"C:\Program Files\Microsoft SQL Server90\Tools\Binn\sqlcmd" -S localhost -i e:\Backupbackup.sql

풀백업

declare @runtime nvarchar(10)
declare @backupdevice nvarchar(100)
declare @backupname nvarchar(100)

set @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2)
set @backupdevice = N'e:\Backupbackup_' + @runtime + N'.bak'
set @backupname = N'backup_' + @runtime

BACKUP DATABASE [TU] TO DISK = @backupdevice WITH NOFORMAT, INIT, NAME = @backupname, SKIP, NOREWIND, NOUNLOAD, STATS = 10

declare @runtime nvarchar(10)

declare @backupdevice nvarchar(100)

declare @backupname nvarchar(100)

set @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2)

set @backupdevice = N'e:\Backupbackup_' + @runtime + N'.bak'

set @backupname = N'backup_' + @runtime

BACKUP DATABASE [TU] TO DISK = @backupdevice WITH NOFORMAT, INIT, NAME = @backupname, SKIP, NOREWIND, NOUNLOAD, STATS = 10

증분 백업

declare @runtime nvarchar(10)
declare @backupdevice nvarchar(100)
declare @backupname nvarchar(100)

set @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2)
set @backupdevice = N'e:\Backupbackup_' + @runtime + N'.bak'
set @backupname = N'backup_' + @runtime

BACKUP DATABASE [TU] TO DISK = @backupdevice WITH DIFFERENTIAL, NOFORMAT, INIT, NAME = @backupname, SKIP, NOREWIND, NOUNLOAD, STATS = 10

declare @runtime nvarchar(10)

declare @backupdevice nvarchar(100)

declare @backupname nvarchar(100)

set @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2)

set @backupdevice = N'e:\Backupbackup_' + @runtime + N'.bak'

set @backupname = N'backup_' + @runtime

BACKUP DATABASE [TU] TO DISK = @backupdevice WITH DIFFERENTIAL, NOFORMAT, INIT, NAME = @backupname, SKIP, NOREWIND, NOUNLOAD, STATS = 10

anydragon

참고자료

최신 글

보관함

sendmail 설정

sql server 백업을 하게 하기 위한 스크립트

태그

링크

메타