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,?
NOFORMAT

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

差异备份
BACKUP DATABASE [ddscm] TO? DISK = N'G:/backup/ddscmdif'
WITH? INIT,? DIFFERENTIAL,? NAME = N'ddscm 备份',?
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?

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!