Skip to main content
Solved

SQL Database export -Question on how it process

N
Forum|alt.badge.img+1
  • Nikks
  • Influencer
  • 90 comments

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.

 
 
 
View original
    Chris.Childerhose
    Madi.Cristil
    2 people like this
    • Chris.Childerhose
      Chris.Childerhose
    • Madi.Cristil
      Madi.Cristil
    Did this topic help you find an answer to your question?

    6 comments

    Chris.Childerhose
    Forum|alt.badge.img+21
    • Chris.Childerhose
    • Veeam Legend, Veeam Vanguard
    • 8486 comments
    • August 13, 2024

    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* | vExpert 6* | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech
    N
    1 person likes this
    • N
      Nikks
    Chris.Childerhose
    Forum|alt.badge.img+21
    • Chris.Childerhose
    • Veeam Legend, Veeam Vanguard
    • 8486 comments
    • 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* | vExpert 6* | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech
    Iams3le
    1 person likes this
    • Iams3le
      Iams3le
    wesmrt
    Forum|alt.badge.img+4
    • wesmrt
    • Veeam MVP
    • 226 comments
    • 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
    1 person likes this
    • Chris.Childerhose
      Chris.Childerhose
    N
    Forum|alt.badge.img+1
    • Nikks
    • Author
    • Influencer
    • 90 comments
    • August 13, 2024
    wesmrt wrote:

    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
    1 person likes this
    • Chris.Childerhose
      Chris.Childerhose
    wesmrt
    Forum|alt.badge.img+4
    • wesmrt
    • Veeam MVP
    • 226 comments
    • August 13, 2024
    Nikks wrote:
    wesmrt wrote:

    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
    1 person likes this
    • Chris.Childerhose
      Chris.Childerhose
    N
    Forum|alt.badge.img+1
    • Nikks
    • Author
    • Influencer
    • 90 comments
    • August 13, 2024
    wesmrt wrote:
    Nikks wrote:
    wesmrt wrote:

    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
    2 people like this
    • Chris.Childerhose
      Chris.Childerhose
    • wesmrt
      wesmrt

    Comment


    Terms & Conditions