SQLSERVER数据库备份

备份数据库和日志

BACKUP DATABASE [ddweb] TO  DISK = N'e:/dailybackup/daily_ddweb'
WITH  INIT ,  NOUNLOAD ,  NAME = N'ddweb 备份',  NOSKIP ,  STATS = 10, 
NOFORMAT

BACKUP LOG [ddweb] TO  DISK = N'e:/dailybackup/ddweblog'
WITH  INIT ,  NOUNLOAD ,  NAME = N'ddweb 备份',  NOSKIP ,  STATS = 10, 
NOFORMAT

每隔15分钟备份日志
BACKUP LOG [ddweb] TO  DISK = N'e:/dailybackup/ddweblog'
WITH  NOINIT ,  NOUNLOAD ,  NAME = N'ddweb 备份',  NOSKIP ,  STATS = 10, 
NOFORMAT

差异备份
BACKUP DATABASE [ddscm] TO  DISK = N'G:/backup/ddscmdif'
WITH  INIT ,  NOUNLOAD ,  DIFFERENTIAL ,  NAME = N'ddscm 备份',  NOSKIP , 
STATS = 10,  NOFORMAT

统计失败的作业
select Count(*) from
msdb.dbo.sysjobhistory a,msdb.dbo.sysjobs b where a.job_id=b.job_id and
a.run_status=0
and run_date=convert(char(10),GETDATE(),112)

统计死锁信息
select count(*) from master.dbo.sysprocesses where lastwaittype like 'lck%'

select * from master.dbo.sysprocesses