SQL Explorer issue

[kubimike]

Setup:
Production server that is protected by Veeam is a 2008 SP4 SQL instance
Staging SQL server is SQL 2014 (a virtual machine)
Veeam B&R is physical v9.5


When performing a restore export to folder the 2008 database is first restored to the staging server (2014). Once its done replaying the transaction logs the export proceeds. The DB and log file are exported to my destination folder of choice.

Issue:
When attempting to mount the exported database on any SQL 2008 instance I get a version is greater then error. No downgrade is possible. This is because the staging server is SQL 2014. The only way around this issue is to make the staging server SQL 2008 and repeat the process.

[foggy]

Hi Mike, this is expected behavior. Database is upgraded upon being attached to SQL 2014, so cannot be then attached to an earlier version.

[kubimike]

OK, however I was doing some practice runs on a SQL 2005 server restoring to "Other server" so I can rename the database. I used the 2014 Staging instance and was able to recover back to 2005. That being the case I think doing a database export should leave the DB in its original version, in this case (100).

[foggy]

Staging server is not used in case of restore, the database was mounted directly to the target server.

[kubimike]

Gotcha. Thank you sir