Migrating database from SQL Express to SQL Server 2012 Std ?

[albertwt]

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.

[Shestakov]

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]

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 ?

[Shestakov]

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

[ccatlett1984]

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]

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

[Vitaliy S.]

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]

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.]

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

[ccatlett1984]

Great to hear.

[puran]

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.