ghost backups processed 0 pages

Question

ghost backups processed 0 pages

Snargables

SSCrazy Eights

Points: 8855
More actions
May 7, 2024 at 12:03 pm

#4419344

I've got something I'm not aware of performing backups of my dbs at random times in the day. I think it is performing backups however it says 0 pages processed. Regardless, anyone have any idea oh how to trouble shoot this?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Snargables SSCrazy Eights Points: 8855 More actions · Answer 1

All of the databases are in simple mode. I've setup the backup process in azure to run full backups on sunday and all other days to run the differential backup.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 2

can you supply a little more detail on the database and where it's situated, you mention azure

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 3

Snargables wrote:

I've got something I'm not aware of performing backups of my dbs at random times in the day. I think it is performing backups however it says 0 pages processed. Regardless, anyone have any idea oh how to trouble shoot this?

WHERE are you getting that information from?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Snargables SSCrazy Eights Points: 8855 More actions · Answer 4

Sorry, let me clarify.

I've got a sql instance on an azure VM. The SQL version is Microsoft SQL Server 2019 (RTM-GDR) (KB5035434) - 15.0.2110.4 (X64) Mar 12 2024 18:25:56 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: ) (Hypervisor)

I'm seeing these backups in the SQL Server Logs. I've attached a sample. This is just a sample. They also show up when i run the below query to view the backup histories. Let me know if you need more information.

I've setup my backup process in azure recovery service vault. It does daily differential backups and a full backup on sundays. This seems to be working fine. Just don't know where these other backups are coming from.

SELECT

CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,

msdb.dbo.backupset.database_name,

msdb.dbo.backupset.backup_start_date,

msdb.dbo.backupset.backup_finish_date,

msdb.dbo.backupset.expiration_date,

CASE msdb..backupset.type

WHEN 'D' THEN 'Database'

WHEN 'L' THEN 'Log'

END AS backup_type,

msdb.dbo.backupset.backup_size,

msdb.dbo.backupmediafamily.logical_device_name,

msdb.dbo.backupmediafamily.physical_device_name,

msdb.dbo.backupset.name AS backupset_name,

msdb.dbo.backupset.description

FROM

msdb.dbo.backupmediafamily

INNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id

WHERE

(CONVERT(datetime, msdb.dbo.backupset.backup_start_date, 102) >= GETDATE() - 7)

ORDER BY

--msdb.dbo.backupset.database_name,

msdb.dbo.backupset.backup_finish_date desc

Attachments:

You must be logged in to view attached files.

Snargables SSCrazy Eights Points: 8855 More actions · Answer 5

Is there something I can track via a trace or in the log To see what is calling this or where it is coming from?

Perry Whittle SSC Guru Points: 234013 More actions · Answer 6

Do you have the SQL iaas agent registered on the vm?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉