SQL BakupSet

Udhayaganesh Pachiyappan 40 Reputation points
2024-10-28T07:24:39.0733333+00:00

In msdb.dbo.backupset table, Backup_Finish_Date date is showing same as start time. I hope there is bug in SQL server 2022. The same is working fine in sql server 2014.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,020 questions
{count} votes

Accepted answer
  1. ZoeHui-MSFT 37,746 Reputation points
    2024-10-29T01:34:52.4566667+00:00

    Hi @Udhayaganesh Pachiyappan,

    The issue seems to be related with your size of database.

    I test locally that when the database is small, it will back up quickly without a second, if i change a large one, the time will be different.User's image

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.