Monitoring and reporting for Veeam Data Platform
Post Reply
BackupDude
Enthusiast
Posts: 31
Liked: 3 times
Joined: Jan 09, 2014 7:22 pm
Full Name: Fabio Vasco
Contact:

Migrate Database from SQL Express to SQL Server

Post by BackupDude »

Greetings,

We are slowly reaching the max database size supported for SQL Express 2008 R2 for our Veeam v8 instance. We would like to move the database currently on the same VM as Veeamone to our production SQL Server. Are there any steps or procedures available to make this happen?
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Migrate Database from SQL Express to SQL Server

Post by Vitaliy S. »

Hi Fabio,

Yes, please follow the instructions from this KB article > http://www.veeam.com/kb1599

Let me know how it goes.
BackupDude
Enthusiast
Posts: 31
Liked: 3 times
Joined: Jan 09, 2014 7:22 pm
Full Name: Fabio Vasco
Contact:

Re: Migrate Database from SQL Express to SQL Server

Post by BackupDude »

yes, this worked.

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

Re: Migrate Database from SQL Express to SQL Server

Post by Vitaliy S. »

Thanks! Also consider reviewing this KB article (#1594) if you have SQL Sever Enterprise edition available. This should boost the performance of all your reports and views.
baber
Veteran
Posts: 665
Liked: 4 times
Joined: Nov 21, 2013 12:02 pm
Full Name: Babak Seyedi nejad
Contact:

[MERGED] how can migrate veeamOne database

Post by baber »

How can migrate Veeam ONE database SQL Server Express edition to the external SQL Server Standard or higher ?
Is that possible do without error ?
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Migrate Database from SQL Express to SQL Server

Post by Shestakov »

Hello Babak,
Please follow this KB article.
baber
Veteran
Posts: 665
Liked: 4 times
Joined: Nov 21, 2013 12:02 pm
Full Name: Babak Seyedi nejad
Contact:

Re: Migrate Database from SQL Express to SQL Server

Post by baber »

I am reading this document
https://www.veeam.com/kb1599

in first step I could get backup from my veeam one sql express on the other hand I have installed sql server but I am confused about this part

Provision a domain account for Veeam ONE Monitor and Veeam ONE Reporter on the new SQL Server. This can be one account or two different accounts. Move the database to the new SQL Server. Depending on Veeam One version, grant the account(s) appropriate permissions:

now what do i have to do ? what does that means ?
baber
Veteran
Posts: 665
Liked: 4 times
Joined: Nov 21, 2013 12:02 pm
Full Name: Babak Seyedi nejad
Contact:

Re: Migrate Database from SQL Express to SQL Server

Post by baber »

would you please help me ?
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Migrate Database from SQL Express to SQL Server

Post by Shestakov »

What exactly haven't you understood?
You need to grant permissions depending on Veeam ONE version.
Note that you can contact Veeam support even being on free version.
Post Reply

Who is online

Users browsing this forum: No registered users and 8 guests