Migrate Database from SQL Express to SQL Server

Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V

Migrate Database from SQL Express to SQL Server

Veeam Logoby BackupDude » Mon 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?
BackupDude
Enthusiast
 
Posts: 31
Liked: 2 times
Joined: Thu Jan 09, 2014 7:22 pm
Full Name: Fabio Vasco

Re: Migrate Database from SQL Express to SQL Server

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

Re: Migrate Database from SQL Express to SQL Server

Veeam Logoby BackupDude » Mon Nov 17, 2014 8:52 pm

yes, this worked.

Thanks
BackupDude
Enthusiast
 
Posts: 31
Liked: 2 times
Joined: Thu Jan 09, 2014 7:22 pm
Full Name: Fabio Vasco

Re: Migrate Database from SQL Express to SQL Server

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


Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 2 guests