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.
northeast100
Novice
 
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
Ctek
Service Provider
 
Posts: 39
Liked: 3 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)

Cheers
Mike
Mike Resseler
Veeam Software
 
Posts: 3290
Liked: 366 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.
mikeconjoice
Service Provider
 
Posts: 6
Liked: never
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: Exabot [Bot], Google [Bot] and 23 guests