Move Lync 2013 Database to new SQL server

I need to move our Lync 2013 database off the Lync server to a new SQL server.  Does anyone have any suggestions or steps they followed, for migrating the SQL to a new server?   Our Lync server is currently on SQL Express and our new server is Server 2012 R2 with SQL 2012.  Thanks
nextechexchadminAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Will SzymkowskiSenior Solution ArchitectCommented:
I did this awhile back and i used some steps I found on someones blog however, microsoft has published this as a TechNet. See the link below.
https://technet.microsoft.com/en-us/library/gg195644(v=ocs.14).aspx

Will.
0
Cliff GaliherCommented:
You are probably looking at a full on migration.  The issue is that if your SQL instance is *on* your Lync server then it is Lync Standard (Lync Enterprise does not allow the SQL instance to be on one of the Lync server pools.)  And if you are moving to a separate SQL server, you need Enterprise, as Lync Standard is exactly opposite of above. It doesn't let you break out SQL completely. That's an enterprise-only feature.  Which means you'll have to create a pool and migrate/move users to the new pool to pull off what you want in this instance.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nextechexchadminAuthor Commented:
I did double check and we are on Lync 2013 standard, so to move the database from SQL Express to a new server, we would need to upgrade our Lync server to the enterprise edition?  Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Chat / IM

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.