Why Are There Backup Messages in My Sql Log When No Scheduled Backups Are Running?
While Troubleshooting a "While Waiting for Buffer Latch -- Type 4" Timeout Error I Checked the Sql Log Files and There Are a Ton of Backup Database and Success...
While troubleshooting a "while waiting for buffer latch -- type 4" timeout error I checked the SQL Log files and there are a TON of BACKUP DATABASE and success statements. There are no scheduled backups (including T-Logs) anywhere near the time of the message below. No maintenance plans either. I also scripted out all the jobs but didn't find anything.
04/27/2021 05:04:15,Backup,Unknown,Database backed up. Database: EDS_Staging<c/> creation date(time): 2019/07/29(09:27:55)<c/> pages dumped: 386<c/> first LSN: 40508:1251:43<c/> last LSN: 40508:1271:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'{D0FDCDF5-6122-409F-83E2-9FE1EB231826}7'}). This is an informational message only. No user action is required.
04/27/2021 05:04:15,Backup,Unknown,BACKUP DATABASE successfully processed 0 pages in 104.536 seconds (0.000 MB/sec).
04/27/2021 05:04:15,Backup,Unknown,BACKUP DATABASE successfully processed 0 pages in 102.651 seconds (0.000 MB/sec).
04/27/2021 05:04:15,Backup,Unknown,BACKUP DATABASE successfully processed 0 pages in 103.459 seconds (0.000 MB/sec).
04/27/2021 05:04:15,Backup,Unknown,Database backed up. Database: PETS<c/> creation date(time): 2019/07/22(08:50:00)<c/> pages dumped: 18107<c/> first LSN: 167131:191:1<c/> last LSN: 167136:716:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'{D0FDCDF5-6122-409F-83E2-9FE1EB231826}6'}). This is an informational message only. No user action is required.
04/27/2021 05:04:15,Backup,Unknown,Database backed up. Database: JTS<c/> creation date(time): 2019/06/05(07:48:59)<c/> pages dumped: 1536<c/> first LSN: 407:4725:1<c/> last LSN: 407:5488:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'{D0FDCDF5-6122-409F-83E2-9FE1EB231826}5'}). This is an informational message only. No user action is required.
04/27/2021 05:04:15,Backup,Unknown,Database backed up. Database: ACR<c/> creation date(time): 2019/03/06(09:31:45)<c/> pages dumped: 709<c/> first LSN: 71:27659:1<c/> last LSN: 71:27862:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'{D0FDCDF5-6122-409F-83E2-9FE1EB231826}4'}). This is an informational message only. No user action is required.
Perhaps these are some sort of "system backups" (I'm not the man when it comes to reading the log). However because they are running at the same time as the task for which I'm getting the buffer latch type 4 errors I'd like to get them out of the way if possible.
Any help or insight would be most welcome. Thank you!