Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V
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 » Nov 17, 2014 7:41 pm

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.
Product Manager
Posts: 22874
Liked: 1540 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. » Nov 17, 2014 8:37 pm

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 » Nov 17, 2014 8:52 pm

yes, this worked.

Thanks

Vitaliy S.
Product Manager
Posts: 22874
Liked: 1540 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. » Nov 17, 2014 8:56 pm

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
Expert
Posts: 650
Liked: 3 times
Joined: Nov 21, 2013 12:02 pm
Full Name: Babak Seyedi nejad
Contact:

[MERGED] how can migrate veeamOne database

Post by baber » Sep 14, 2019 4:38 am

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
Veeam Software
Posts: 6916
Liked: 700 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 » Sep 15, 2019 9:31 am

Hello Babak,
Please follow this KB article.

baber
Expert
Posts: 650
Liked: 3 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 » Sep 16, 2019 11:59 am

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
Expert
Posts: 650
Liked: 3 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 » Sep 17, 2019 1:24 am

would you please help me ?

Shestakov
Veeam Software
Posts: 6916
Liked: 700 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 » Sep 17, 2019 3:24 pm

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 2 guests