Skip to main content

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?

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


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

 
 
 

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.


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 ?


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.


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


Comment