Solved

Steps how to move SCCM database to sql server 2008.

Posted on 2010-09-16
4
1,466 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

Turn Insights Into Action

You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.

With xMatters, you'll never miss a beat.

Question has a verified solution.

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

Some time ago I faced the need to use a uniform folder structure that spanned across numerous sites of an enterprise to be used as a common repository for the Software packages of the Configuration Manager 2007 infrastructure. Because the procedu…
Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

717 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