Migrating database from SQL Express to SQL Server 2012 Std ?

Real-time performance monitoring and troubleshooting

Migrating database from SQL Express to SQL Server 2012 Std ?

Veeam Logoby albertwt » Wed 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 ! */
albertwt
Expert
 
Posts: 621
Liked: 20 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

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

Veeam Logoby Shestakov » Wed 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!
Shestakov
Veeam Software
 
Posts: 5208
Liked: 433 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

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

Veeam Logoby albertwt » Thu 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 ! */
albertwt
Expert
 
Posts: 621
Liked: 20 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

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

Veeam Logoby Shestakov » Thu Dec 11, 2014 10:54 am 1 person likes this post

You are welcome, Albert.
You need to attach, detach. Thanks.
Shestakov
Veeam Software
 
Posts: 5208
Liked: 433 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

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

Veeam Logoby ccatlett1984 » Mon 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?
ccatlett1984
Enthusiast
 
Posts: 83
Liked: 9 times
Joined: Thu Oct 31, 2013 5:11 pm
Full Name: Chris Catlett

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

Veeam Logoby albertwt » Mon 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 ! */
albertwt
Expert
 
Posts: 621
Liked: 20 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

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

Veeam Logoby Vitaliy S. » Tue 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.
Vitaliy S.
Veeam Software
 
Posts: 20106
Liked: 1160 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

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

Veeam Logoby ccatlett1984 » Tue 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.
ccatlett1984
Enthusiast
 
Posts: 83
Liked: 9 times
Joined: Thu Oct 31, 2013 5:11 pm
Full Name: Chris Catlett

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

Veeam Logoby Vitaliy S. » Tue 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
Vitaliy S.
Veeam Software
 
Posts: 20106
Liked: 1160 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

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

Veeam Logoby ccatlett1984 » Tue Oct 20, 2015 1:35 pm

Great to hear.
ccatlett1984
Enthusiast
 
Posts: 83
Liked: 9 times
Joined: Thu Oct 31, 2013 5:11 pm
Full Name: Chris Catlett

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

Veeam Logoby puran » Thu 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.
puran
Lurker
 
Posts: 2
Liked: 1 time
Joined: Fri Aug 25, 2017 8:50 am
Full Name: puran


Return to Monitoring



Who is online

Users browsing this forum: No registered users and 1 guest