SQL Explorer issue

Availability for the Always-On Enterprise

SQL Explorer issue

Veeam Logoby kubimike » Sun Apr 02, 2017 6:19 pm

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.
kubimike
Expert
 
Posts: 133
Liked: 20 times
Joined: Fri Feb 03, 2017 2:34 pm
Full Name: MikeO

Re: SQL Explorer issue

Veeam Logoby foggy » Mon Apr 03, 2017 9:43 am

Hi Mike, this is expected behavior. Database is upgraded upon being attached to SQL 2014, so cannot be then attached to an earlier version.
foggy
Veeam Software
 
Posts: 14094
Liked: 1027 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Explorer issue

Veeam Logoby kubimike » Mon Apr 03, 2017 1:20 pm

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).
kubimike
Expert
 
Posts: 133
Liked: 20 times
Joined: Fri Feb 03, 2017 2:34 pm
Full Name: MikeO

Re: SQL Explorer issue

Veeam Logoby foggy » Tue Apr 04, 2017 2:31 pm

Staging server is not used in case of restore, the database was mounted directly to the target server.
foggy
Veeam Software
 
Posts: 14094
Liked: 1027 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Explorer issue

Veeam Logoby kubimike » Tue Apr 04, 2017 4:19 pm

Gotcha. Thank you sir :)
kubimike
Expert
 
Posts: 133
Liked: 20 times
Joined: Fri Feb 03, 2017 2:34 pm
Full Name: MikeO


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Google [Bot] and 7 guests