Comprehensive data protection for all workloads
Post Reply
hobensovbr
Novice
Posts: 8
Liked: 1 time
Joined: Nov 05, 2013 12:18 pm
Full Name: Ben Holland
Contact:

Migration of SQL 2008 R2 express to 2012 Standard

Post by hobensovbr »

Hi Guy's,

Just after some advice if possible.

I have Veeam Backup & Replication version 7 installed on Windows Server 2012.
The SQL database version is 2008 R2 Express.
The problem with this is most of the databases I would like to restore are over the 10GB limit, therefore won't work under express.

I would like to upgrade to SQL 2012 Standard.
What would be the best course of action:

In place upgrade.
Install new instance on the same server and copy the Veeam DB.
Install new Instance on another server and copy the Veeam DB.

Also are there any caveats I should be aware of?

Thanks for your help.

Ben
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Migration of SQL 2008 R2 express to 2012 Standard

Post by Vitaliy S. »

Hi Ben,

Not sure I fully understand the correlation between SQL Server used by Veeam backup server and databases you want to restore. Can you please clarify?

Thanks!
hobensovbr
Novice
Posts: 8
Liked: 1 time
Joined: Nov 05, 2013 12:18 pm
Full Name: Ben Holland
Contact:

Re: Migration of SQL 2008 R2 express to 2012 Standard

Post by hobensovbr »

Hi,

Thanks for getting back to me.

When I try to restore a SharePoint Item for example I get the following error when it tries to mount the database:
"CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 1024MB per database"

When I checked this error on the Veeam KB website I found this article:
http://www.veeam.com/kb1769

Cause:
Apparently, provided SQL server might be Express Edition as a result you may face with known limitation of the SQL Server:
◾ SQL Server 2005/2008 Express Edition – maximum database size 4 GiB;
◾ SQL Server 2008 R2/2012 Express Edition – maximum database size 10 GiB;

Solution:
Specify SQL Server Full Edition in the options of Veeam Explorer for SharePoint.

This cause fits my problem exactly because Veeam Backup is running on a SQL Server 2008 R2/2012 Express Edition.
With this in mind I just wanted to confirm the upgrade process from a Veeam point of view.

I hope this explains my problem in a bit more detail.

Regards,
Ben
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Migration of SQL 2008 R2 express to 2012 Standard

Post by Vitaliy S. » 1 person likes this post

Hi Ben,

Ok, now it makes sense. To address this issue you do not need to upgrade Veeam SQL database to the full edition. You can just use any standalone existing SQL Server to mount SharePoint database. As regards the SQL Server upgrade procedure, then in-place upgrade seems like the easiest option for me.

Thanks!
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Migration of SQL 2008 R2 express to 2012 Standard

Post by foggy » 1 person likes this post

Be sure to backup Veeam B&R configuration prior upgrading SQL Server, if you decide to go this way. Just to be on the safe side.
hobensovbr
Novice
Posts: 8
Liked: 1 time
Joined: Nov 05, 2013 12:18 pm
Full Name: Ben Holland
Contact:

Re: Migration of SQL 2008 R2 express to 2012 Standard

Post by hobensovbr »

Ok Thanks for the advice.
My preference would be to keep it all on the local server.

I did the config backup and went ahead with the in place upgrade from 2008R2 Express to 2012 Standard.
Just followed the upgrade wizard in the install and it worked like a charm.

Now the database mounts as expected.

Many thanks for your help.

Regards,
Ben
albertwt
Veeam Legend
Posts: 879
Liked: 46 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

[MERGED] Migrating database from SQL Express to SQL Server 2

Post by albertwt »

Hi Veeam team,

Can you please share me the steps to perform VBR database migration from the build-in SQL Server Express 2008 R2 into SQL Server 2012 Standard Edition ?

Is there any information or settings that is lost or any other caveats that I need to know beforehand ?
--
/* Veeam software enthusiast user & supporter ! */
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Migration of SQL 2008 R2 express to 2012 Standard

Post by foggy »

Albert, just perform Veeam B&R configuration backup first and then an in-place upgrade of the SQL Server. Thanks.
Post Reply

Who is online

Users browsing this forum: No registered users and 162 guests