The following forum(s) have migrated to Microsoft Q&A: All English System Center 2012 Configuration Manager forums!
Visit Microsoft Q&A to post new questions.

Learn More

Remove From My Forums

Migration to embedded SQL

Question
0

Sign in to vote

Hi,

I am currently in the process of moving a client's database from a separate SQL instance to an SCCM installation using the embedded SQL standard instance.

Are there any guides for moving to the embedded sql instance ?

The client is hell bent on switching to the embedded SQL instance, so unfortunately there is no way around it.

Thanks in advance !

Monday, August 3, 2015 2:43 AM

Answers

0

Sign in to vote
So you just want to move the SQL database from a remote server to a SQL instance that's installed on the site server? This should get you started: http://blogs.technet.com/b/configurationmgr/archive/2013/04/02/how-to-move-the-configmgr-2012-site-database-to-a-new-sql-server.aspx
Torsten Meringer | http://www.mssccmfaq.de
- Proposed as answer by Jason Sandys [MSFT]MVP Monday, August 3, 2015 2:01 PM
- Marked as answer by Pappagussepi Monday, August 3, 2015 11:35 PM
Monday, August 3, 2015 7:21 AM

All replies

0

Sign in to vote

What exactly do you mean by embedded SQL?
Garth Jones | My blogs: Enhansoft and Old Blog site | Twitter: @GarthMJ

Monday, August 3, 2015 2:46 AM
0

Sign in to vote

Btw you can remind them that they will be required to buy SQL licenses if the SQL server is not exclusively use for cm12.
Garth Jones | My blogs: Enhansoft and Old Blog site | Twitter: @GarthMJ

Monday, August 3, 2015 2:47 AM
0

Sign in to vote

I mean on the same server as the sccm instance by embedded. I'm sure they're trying to cut costs by having standard sql on the server.

Monday, August 3, 2015 5:17 AM
0

Sign in to vote
So you just want to move the SQL database from a remote server to a SQL instance that's installed on the site server? This should get you started: http://blogs.technet.com/b/configurationmgr/archive/2013/04/02/how-to-move-the-configmgr-2012-site-database-to-a-new-sql-server.aspx
Torsten Meringer | http://www.mssccmfaq.de
- Proposed as answer by Jason Sandys [MSFT]MVP Monday, August 3, 2015 2:01 PM
- Marked as answer by Pappagussepi Monday, August 3, 2015 11:35 PM
Monday, August 3, 2015 7:21 AM
0

Sign in to vote

Thanks !

Monday, August 3, 2015 11:35 PM