Solved

Steps how to move SCCM database to sql server 2008.

Posted on 2010-09-16
4
1,465 Views
Last Modified: 2013-11-21
Hi all,
We are moving the SCCM database to SQL server 2008. The SCCM database is now on SQL server 2005. Could you please give me some sources or ideas how to do that?
Thank you
0
Comment
Question by:dongocdung
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 6

Expert Comment

by:TarekIsmail
ID: 33696468
so you have the old server running SQL 2005 and the new server running SQL 2008.
the easy way to move database from SQL 2005 to SQL 2008 using :
1-Detaching the Database
2- Copy the DATA / LOG Files
3- Attaching the Database

Moving a Database from SQL Server 2005 to SQL Server 2008 in Three Steps
http://www.packtpub.com/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps.

after you move the SQL database to the new server you can use the steps in the KB below
http://technet.microsoft.com/en-us/library/bb680707.aspx

Good Luck!
Tarek Ismail

0
 

Author Comment

by:dongocdung
ID: 33702946
I will try it and let you know later
thank you
0
 

Author Comment

by:dongocdung
ID: 33728749
Hi TarekIsmail,
When I tried to this step:

Select Modify SQL Server configuration on the Configuration Manager Setup Wizard Site Maintenance page.

I entered  the SQL server name and instance but I got this error msg
"Could not connect or execute SQL query".
 I verified the SQL and instance name. They are correct. Do you why?
Thank you
0
 
LVL 6

Accepted Solution

by:
TarekIsmail earned 500 total points
ID: 33729049

make sure to configure firewall on sql 2008 server allow access from remote computers

and make sure the sql server support tcp/ip and named pipe.

0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The environment that this is running in is SCCM 2007 R2 running on a Windows 2008 R2 server. The PXE Distribution point is running on its own Windows 2008 R2 box. This is what Event viewer showed after trying to start the WDS service:  An erro…
Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip Migration Tip #1 – Source Server Health can be found listed in my profile here: http:…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question