Forum Discussion

Ludo88's avatar
Ludo88
Copper Contributor
Mar 10, 2023

Native Azure DevOps Server backup vs SQL Server

Hi the community!

 

I'm looking for official information about the difference between backups built via the Azure DevOps Server Administration Console and backup of databases using SQL maintenance plan.

 

Thanks in advance

 

Regards

Azure DevOps
  • chanduvsc's avatar
    chanduvsc
    Mar 13, 2023
    No such recommendation. DBAs in general take care of Marked transactions when they take backups in SQL. All upto SQL DBA or TFS admin how they want to take backups.
  • chanduvsc's avatar
    chanduvsc
    Icon for Microsoft rankMicrosoft
    Mar 13, 2023

    Ludo88 

    You can use any one of it. At the end, Backup in TFS creates a job in SQL to schedule. It is more SQL activity.

    If you have a DBA, its better he takes care of the backup\restore through a maintenance plan.

    Any specific questions, let me know.

    • Ludo88's avatar
      Ludo88
      Copper Contributor
      Mar 13, 2023
      thanks chanduvsc for your answer. I though that doing the backup via the Admin Console provide more guaranties. For instance, if i do my backups via SQL, I do "warm" backup. I had in mind that passing via le Admin Console bring more consistency in my backup.
      So, I wanted to know. So, you do confirm that both systems provide the same results with same guaranties ?
      • chanduvsc's avatar
        chanduvsc
        Icon for Microsoft rankMicrosoft
        Mar 13, 2023
        Only one additional thing which you get from TFS backup is "marked transactions" by default. Where as in SQL, DBA has to take care of it while taking a backup for an online database.

Resources