Video Screencast Help

database migration sql express to sql 2008 R2

Created: 03 Jul 2014 | 1 comment
Elmer Gomez's picture

good afternoon,
I have installed backup exec 2012 on which works with a sql database express, the problem is that you quickly fill your data that exceeds 4 GB,
the need I have is to make the migration of database sql express database to sql 2008 R2 since it has licensed.
my question is there will be a process of good practice for such migration

thank you for your help thanks.

Operating Systems:

Comments 1 CommentJump to latest comment

pkh's picture

I think you may be suffering from this known problem.  See this document on how to solve the problem

You need to use the procedure in the document to shrink the BELog table before upgrading to SP4.  Remember to push out the remote agents after you have upgraded to SP4.

If you still want to move your BEDB, then use the procedure in this document

Make sure you give BE its own instance because occasionally you might need to restart the BE SQL instance and you don't want to disrupt any existing production databases.