Comprehensive data protection for all workloads
Post Reply
northeast100
Novice
Posts: 3
Liked: never
Joined: Nov 10, 2016 6:50 pm
Contact:

SQL Edition Upgrade - Express to Standard.

Post by northeast100 »

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.

Ctek
Service Provider
Posts: 71
Liked: 9 times
Joined: Nov 11, 2015 3:50 pm
Location: Canada
Contact:

Re: SQL Edition Upgrade - Express to Standard.

Post by Ctek »

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

Mike Resseler
Product Manager
Posts: 6498
Liked: 818 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: SQL Edition Upgrade - Express to Standard.

Post by Mike Resseler »

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

mikeconjoice
Veeam Vanguard
Posts: 7
Liked: 1 time
Joined: May 09, 2016 3:59 pm
Full Name: Mike Conjoice
Location: UK
Contact:

Re: SQL Edition Upgrade - Express to Standard.

Post by mikeconjoice »

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.

Post Reply

Who is online

Users browsing this forum: Baidu [Spider], Bing [Bot] and 35 guests