Post reply

ghost backups processed 0 pages

  • 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?

  • May 7, 2024 at 12:07 pm

    #4419347

    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.

     

  • May 8, 2024 at 11:05 am

    #4419707

    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" 😉

  • May 8, 2024 at 7:41 pm

    #4419877

    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)

  • May 9, 2024 at 3:41 pm

    #4420059

    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.

  • May 16, 2024 at 5:30 pm

    #4421770

    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?

  • May 16, 2024 at 5:59 pm

    #4421775

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

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

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

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

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