mssql Äõ¸® °ü·Ã Áú¹®

   Á¶È¸ 1103   Ãßõ 0    

 

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'
)
     
L2½ºÀ§Ä¡ 2022-02
´äº¯ °¨»çÇÕ´Ï´Ù~!

¤¾¤¾ ´ñ±Û Áֽñâ Àü¿¡ ´äÀ» ã¾Ò½À´Ï´Ù~! ´ñ±Ûµµ Âü°íÇÏ°Ú½À´Ï´Ù °¨»çÇÕ´Ï´Ù!


QnA
Á¦¸ñPage 338/420
2020-09   2786   ¿Ã»©¹ÌÀá¿Í
2020-09   3620   ±èȲÁß
2021-08   2007   VSPress
2020-09   2418   Áö¼ö»ïÃÌ
2021-08   3955   ¾î²Ù±â
2021-08   2679   VSPress
2021-08   2292   VSPress
2021-07   3257   Âî·Ï
2021-07   1871   NaHS
2021-07   1714   ¸¶Áö¸·¼¼´ë
2020-08   4870   shefef
2021-07   2034   weikath
2020-08   3348   °ø¹é±â
2020-08   2535   ¼ö·¹¹ÙÄû
2020-08   2455   ¼ÒÁÖÇѺ´
2020-08   2655   ¸£³ªÇ®½º
2021-07   2193   ¿µ»êȸ»ó
2020-08   2674   ¾ØµåÀ¯Àú
2021-06   2334   ³²»§
2021-06   2246   inquisitive