SQL Edition Upgrade - Express to Standard.

Availability for the Always-On Enterprise

SQL Edition Upgrade - Express to Standard.

Veeam Logoby northeast100 » Mon Jun 12, 2017 6:47 pm

Hey all,

We are moving our SQL databases over to Veeam from backupexec and we have read that if you have databases larger than 10GB then express won't work for Veeam. So we are wondering if anyone has gone through an express to standard upgrade. Our setup is all-in-one physical server. SQL and Veeam. Appreciate any input/feedback.
Posts: 3
Liked: never
Joined: Thu Nov 10, 2016 6:50 pm

Re: SQL Edition Upgrade - Express to Standard.

Veeam Logoby Ctek » Mon Jun 12, 2017 8:58 pm

We did it in the past for SQL Express 2008 to Standard, it was a walk in the park. We just did the GUI upgrade of SQL and it went fine. Just make sure you do backups properly before.
VMCE 9 Certified - Systems Administrator
Service Provider
Posts: 55
Liked: 7 times
Joined: Wed Nov 11, 2015 3:50 pm
Location: Canada

Re: SQL Edition Upgrade - Express to Standard.

Veeam Logoby Mike Resseler » Tue Jun 13, 2017 6:46 am

MSFT has created some good documentation naroud this: https://docs.microsoft.com/en-us/sql/da ... n-upgrades

And as Ctek says, it should not be that difficult at all, and I agree with him, always take a backup before doing something like this :-) (PS: If you are already running Veeam on that database, you can do a config backup: https://helpcenter.veeam.com/docs/backu ... tml?ver=95)

Mike Resseler
Veeam Software
Posts: 4269
Liked: 477 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: SQL Edition Upgrade - Express to Standard.

Veeam Logoby mikeconjoice » Tue Jun 13, 2017 10:51 am

Just echoing what the other guys have said here, it's really straightforward. We've just done it on a large number of servers and it's very much a next, next, next, upgrade process. I can send you the steps we followed if you like but as Mike and Ctek said, it's nicely documented on the Microsoft Docs site.
Veeam Vanguard
Posts: 7
Liked: 1 time
Joined: Mon May 09, 2016 3:59 pm
Location: UK
Full Name: Mike Conjoice

Return to Veeam Backup & Replication

Who is online

Users browsing this forum: Bing [Bot], dcolpitts, Google [Bot] and 68 guests