How to move the Veeam db from sql express to production sql

Availability for the Always-On Enterprise

How to move the Veeam db from sql express to production sql

Veeam Logoby marieelieg » Tue Dec 20, 2016 7:58 pm

Hello everyone,

Sorry if this is a redundant question but I tried searching and I couldn't find anything. So here goes.

I installed VBR9 on a VM and used the free sql express that came with it for the Veeam db. I want to move this Veeam db to a full version of sql that is deployed in production.

Can you please post the exact steps that are needed here? or post a link to an article that contains the steps?

Thank you all in advance :D
marieelieg
Enthusiast
 
Posts: 69
Liked: 3 times
Joined: Thu Oct 20, 2016 7:15 am

Re: How to move the Veeam db from sql express to production

Veeam Logoby DaveWatkins » Wed Dec 21, 2016 12:37 am 1 person likes this post

https://www.veeam.com/kb1448

and this

https://www.veeam.com/kb1250

give an overview, basically detach the DB from the embedded SQL, move the files to the new server you want to use, attach the files and configure access, then either change the registry entries or use the DBConfig Utility

Take a config backup beforehand as a fallback measure
DaveWatkins
Expert
 
Posts: 271
Liked: 68 times
Joined: Sun Dec 13, 2015 11:33 pm

Re: How to move the Veeam db from sql express to production

Veeam Logoby marieelieg » Wed Dec 21, 2016 12:25 pm

Okay thank you so much !! :D
marieelieg
Enthusiast
 
Posts: 69
Liked: 3 times
Joined: Thu Oct 20, 2016 7:15 am


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot] and 24 guests