-
- 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
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?
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?
-
- VP, Product Management
- Posts: 27377
- Liked: 2800 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Migrate Database from SQL Express to SQL Server
Hi Fabio,
Yes, please follow the instructions from this KB article > http://www.veeam.com/kb1599
Let me know how it goes.
Yes, please follow the instructions from this KB article > http://www.veeam.com/kb1599
Let me know how it goes.
-
- 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
yes, this worked.
Thanks
Thanks
-
- VP, Product Management
- Posts: 27377
- Liked: 2800 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Migrate Database from SQL Express to SQL Server
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.
-
- 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
How can migrate Veeam ONE database SQL Server Express edition to the external SQL Server Standard or higher ?
Is that possible do without error ?
Is that possible do without error ?
-
- 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
Hello Babak,
Please follow this KB article.
Please follow this KB article.
-
- 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
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 ?
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 ?
-
- 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
would you please help me ?
-
- 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
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.
You need to grant permissions depending on Veeam ONE version.
Note that you can contact Veeam support even being on free version.
Who is online
Users browsing this forum: No registered users and 12 guests