Real-time performance monitoring and troubleshooting
Post Reply
albertwt
Expert
Posts: 626
Liked: 20 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

Migrating database from SQL Express to SQL Server 2012 Std ?

Post by albertwt » Dec 10, 2014 12:38 pm

Hi Veeam ONE team,

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

Is there any information or settings that could be lost during or after the migration or any other caveats that I need to know beforehand?

Thanks in advance.
--
/* Veeam software enthusiast user & supporter ! */

Shestakov
Veeam Software
Posts: 5970
Liked: 521 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Migrating database from SQL Express to SQL Server 2012 S

Post by Shestakov » Dec 10, 2014 2:26 pm 2 people like this post

Hello Albert,

It can be done using Veeam settings:
First, provision a domain account for Veeam ONE Monitor and Veeam ONE Reporter on the new SQL Server. Move the database to the new SQL Server. Grant to the account(s) db_owner permissions on the VeeamOne database.
Than you need to modify the accounts that are used by monitoring and reporting components of Veeam ONE.

Modify connection settings for Veeam ONE Monitor:
1) Launch the Veeam ONE Settings utility under this path: C:\Program Files\Common Files\Veeam\Veeam ONE Settings\VeeamOneSettings.exe
2) In the menu on the left, select General, open the Database tab and make the necessary changes in the SQL Server section.
3) Make sure this account has sufficient privileges on the Veeam ONE database on the SQL Server side.
4) Click the Test Connection button to check whether new configuration settings are correct.
5) Save changes and Restart Veeam ONE Monitor Server service.

Modify connection settings for Veeam ONE Reporter and Business View:
1) In the list of services, locate Veeam ONE Reporter Server service and choose to modify its properties. Open the Log On tab and specify the necessary account for the service in the Log on as section.
2) Make sure this account has sufficient privileges on the Veeam ONE database on the SQL Server side, as it will be used for data collection.
3) Launch the Veeam ONE Settings utility under this path: C:\Program Files\Common Files\Veeam\Veeam ONE Settings\VeeamOneSettings.exe
4) In the menu on the left, select General, open the Web Identity tab and make the necessary changes in the Web identity section.
5) Make sure this account has sufficient privileges on the Veeam ONE database on the SQL Server side, as it will be used for overall Web UI operation and reports creation.
6) Save changes and restart Veeam ONE Reporter Server service.

We also have a corresponding KB article. Thanks!

albertwt
Expert
Posts: 626
Liked: 20 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

Re: Migrating database from SQL Express to SQL Server 2012 S

Post by albertwt » Dec 11, 2014 4:06 am

Cool, many thanks for the explanation.

In this case do I need to copy paste or detach and attach the database to the new server ?
--
/* Veeam software enthusiast user & supporter ! */

Shestakov
Veeam Software
Posts: 5970
Liked: 521 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Migrating database from SQL Express to SQL Server 2012 S

Post by Shestakov » Dec 11, 2014 10:54 am 1 person likes this post

You are welcome, Albert.
You need to attach, detach. Thanks.

ccatlett1984
Enthusiast
Posts: 83
Liked: 9 times
Joined: Oct 31, 2013 5:11 pm
Full Name: Chris Catlett
Contact:

Re: Migrating database from SQL Express to SQL Server 2012 S

Post by ccatlett1984 » Oct 19, 2015 9:19 pm

I detached my database, and attached it to the new sql server.

I am having an issue where it will not let me open the configuration tool, I get an error that it can't login to the database.
Ideas?

albertwt
Expert
Posts: 626
Liked: 20 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

Re: Migrating database from SQL Express to SQL Server 2012 S

Post by albertwt » Oct 19, 2015 10:11 pm

Chris,

By default, the security / login is not created when you do the attach detach method.

Have you export the SQL login ?
Refer to this: https://support.microsoft.com/en-us/kb/918992
--
/* Veeam software enthusiast user & supporter ! */

Vitaliy S.
Veeam Software
Posts: 21544
Liked: 1285 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Migrating database from SQL Express to SQL Server 2012 S

Post by Vitaliy S. » Oct 20, 2015 9:59 am

Also the recommended way to migrate the database is to do that via configuration tool. Chris, our support team will be able to help you with the configuration file that is used when launching Veeam ONE and the support utility you're referencing above.

ccatlett1984
Enthusiast
Posts: 83
Liked: 9 times
Joined: Oct 31, 2013 5:11 pm
Full Name: Chris Catlett
Contact:

Re: Migrating database from SQL Express to SQL Server 2012 S

Post by ccatlett1984 » Oct 20, 2015 1:26 pm

I do have a case open #01086978

I am not using sql auth.
I have granted the correct security on both the sql instance, as well as the database.

I am unable to open the config tool to point it to the new sql instance.

Vitaliy S.
Veeam Software
Posts: 21544
Liked: 1285 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Migrating database from SQL Express to SQL Server 2012 S

Post by Vitaliy S. » Oct 20, 2015 1:28 pm

Seems like you're having the same issue, so out team should assist quickly > VeeamOne Settings will not open

ccatlett1984
Enthusiast
Posts: 83
Liked: 9 times
Joined: Oct 31, 2013 5:11 pm
Full Name: Chris Catlett
Contact:

Re: Migrating database from SQL Express to SQL Server 2012 S

Post by ccatlett1984 » Oct 20, 2015 1:35 pm

Great to hear.

puran
Novice
Posts: 4
Liked: 1 time
Joined: Aug 25, 2017 8:50 am
Full Name: puran
Contact:

Re: Migrating database from SQL Express to SQL Server 2012 S

Post by puran » Dec 07, 2017 7:27 am 1 person likes this post

The migration task can also be performed using SysTools SQL Server Database Migration which allows migration between database to database, Server to Server and Machine to Machine.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest