Skip to main content
Answer

SQL Database export -Question on how it process

  • August 13, 2024
  • 6 comments
  • 84 views
N
Forum|alt.badge.img+1

Regarding the SQL database export, using SQL staging server, it appears that the export was executed from the existing production instance rather than from the Veeam backup storage media. This suggests that a direct export from the Veeam backup storage is not possible, which is what I wanted to verify.

As a result, Veeam management tools will be required to restore the SQL database and its transaction logs to a specific point in time using the Veeam backup storage media.

Is my understanding correct?

Best answer by Chris.Childerhose

But if you look at the diagram it appears that it is using the repository for export.

 
 
 
    Chris.Childerhose
    Madi.Cristil

    6 comments

    Chris.Childerhose
    Forum|alt.badge.img+21

    The following explains the export process and it seems like how it worked for you is correct - How Export Works - Veeam Backup Explorers Guide

    Chris Childerhose - VMCA2024 | VMCE2023 | VMCE-SP2024 | Veeam Vanguard 8* | Veeam Legend 5* | VUG Canada Leader | vExpert 6* | Toronto VMUG Leader | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech
    N
    Chris.Childerhose
    Forum|alt.badge.img+21
    • Chris.Childerhose
    • Veeam Legend, Veeam Vanguard
    • Answer
    • August 13, 2024

    But if you look at the diagram it appears that it is using the repository for export.

     
     
     
    Chris Childerhose - VMCA2024 | VMCE2023 | VMCE-SP2024 | Veeam Vanguard 8* | Veeam Legend 5* | VUG Canada Leader | vExpert 6* | Toronto VMUG Leader | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech
    Iams3le
    wesmrt
    Forum|alt.badge.img+4
    • wesmrt
    • Veeam MVP
    • August 13, 2024

    If you are using the Staging, we use this server to mount the database and then export to a BAK/MDF file. It’s expected because we need the SQL tools to perform this.

    Wesley Martins @ Senior Enginner at Veeam Technical Support - Public Cloud | My blog: https://itproland.com.br (PT-BR)
    Chris.Childerhose
    N
    Forum|alt.badge.img+1
    • Nikks
    • Author
    • Influencer
    • August 13, 2024

    If you are using the Staging, we use this server to mount the database and then export to a BAK/MDF file. It’s expected because we need the SQL tools to perform this.

    Is this export  done from existing production instance, and not from the veeam backup storage media ?

    Chris.Childerhose
    wesmrt
    Forum|alt.badge.img+4
    • wesmrt
    • Veeam MVP
    • August 13, 2024

    If you are using the Staging, we use this server to mount the database and then export to a BAK/MDF file. It’s expected because we need the SQL tools to perform this.

    Is this export  done from existing production instance, and not from the veeam backup storage media ?

    No, we use the backups created by Veeam, but the data is mounted inside the Staging to them export the database to the file.

    Wesley Martins @ Senior Enginner at Veeam Technical Support - Public Cloud | My blog: https://itproland.com.br (PT-BR)
    Chris.Childerhose
    N
    Forum|alt.badge.img+1
    • Nikks
    • Author
    • Influencer
    • August 13, 2024

    If you are using the Staging, we use this server to mount the database and then export to a BAK/MDF file. It’s expected because we need the SQL tools to perform this.

    Is this export  done from existing production instance, and not from the veeam backup storage media ?

    No, we use the backups created by Veeam, but the data is mounted inside the Staging to them export the database to the file.

    Thanks for clarifying it

    Chris.Childerhose
    wesmrt
    Terms & ConditionsAccessibility statement