160;
select name from sys.databases
except
select distinct database_name from msdb.dbo.backupset WHERE backup_start_date >= DATEADD(hh, -24, GETDATE())
AND backup_start_date < GETDATE()
AND Type = 'D'
1060;런식1004;/196;해서 0177;업1060; 안.108; 데1060;터베1060;스만 체크를 Ȣ16;/140;고 Ȣ16;lj16;데, 데1060;터베1060;스 개수가 많1012; ᅆ1;우에lj16;
속도가 너무 lj12;리네요..160;
except가 A - B1060;니, 순서를 0148;꿀 수도 없고..160;
ᕬ1;시 1339;1008; 0169;법1060; 1080;1012;까요?160;
( ¾Æ´Ò ¼öµµ ÀÖ½À´Ï´Ù. ^^
bÁýÇÕÀÌ Å¬¶§´Â Á¸Àç üũÁ¶°ÇÀÌ º¸Åë ºü¸§)
select name from sys.databases a WITH(NOLOCK)
WHERE NOT EXISTS (
SELECT TOP 1 1
from msdb.dbo.backupset b WITH(NOLOCK)
WHERE b.database_name=a.name
AND backup_start_date >= DATEADD(hh, -24, GETDATE())
AND backup_start_date < GETDATE()
AND Type = 'D'
)
¤¾¤¾ ´ñ±Û Áֽñâ Àü¿¡ ´äÀ» ã¾Ò½À´Ï´Ù~! ´ñ±Ûµµ Âü°íÇÏ°Ú½À´Ï´Ù °¨»çÇÕ´Ï´Ù!