sqlserver的日常检查脚本归结

核心提示：d.name --Step 13 : Getting backup details Select distinct b.machine_name as 'ServerName',

d.name                      

--Step 13 : Getting backup details 

Select distinct                           　

b.machine_name as 'ServerName',                        

b.server_name as 'InstanceName',                        

b.database_name as 'DatabaseName',                            

d.dbid 'DBID',                            

CASE b.[type]                                  

WHEN 'D' THEN 'Full'                                  

WHEN 'I' THEN 'Differential'                                  

WHEN 'L' THEN 'Transaction Log'                                  

END as 'BackupType'                               　

from sysdatabases d inner join msdb.dbo.backupset b                            

On b.database_name =d.name 　

--Step 14: Dropping the table we created for IP and Physical memory

Drop Table TMP

Drop Table IPADD

drop table Nodes

end

go

--Step 15 : Setting Nulls and Quoted identifier back to Off 

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

print '*********************************'

print '

    '

print '

    '

print '

    '

print '

    '

print '----------------------------'

print ' 1.sqlserver all information  '

print '----------------------------'

print '                             '

print '*********************************'

use master

go

print 'ths information about sqlserver '

print '                                '