MRaybone Posted June 8, 2010 Report post Posted June 8, 2010 Hi all, I'm about to upgrade our Central site server and the only major change aside from the hardware will be that the database will be put onto an instance of SQL 2008 SP1. Are there any configuration issues/fixes/patches that I need to be aware of before I make this transition? Cheers, MRaybone. Quote Share this post Link to post Share on other sites More sharing options...
jamitupya Posted June 9, 2010 Report post Posted June 9, 2010 the new DB Server MUST match to the same as the old DB Server... from what i remember.... you can't go from SQL2008 to 2008 SP1 - all kinda bad things happen (experienced first hand) so , i suggest if thats what your doing think about it some more, if you HAVE to take it to an updated version, do some research. LAB it, try it there first. From past experiences, we went from SQL2005 SP2 (old server) to SQL2005 SP2 (Temp Server) - Upgraded the DB Server to 2008 SP1 then relocated to permanent server. this was clustered though.... also checkout: http://www.windows-noob.com/forums/index.php?/topic/693-guide-moving-your-site-database/ and confirm your collation is the same on both old and new. If you have to schedule downtime, schedule some weekend work as when ours failed we had to restore from backup. Quote Share this post Link to post Share on other sites More sharing options...
MRaybone Posted June 9, 2010 Report post Posted June 9, 2010 Well, when I said upgrade, I'll be totally replacing the server and creating a new DB, and detaching/reattaching all the Primary Child sites to the new Central site. They are all running SQL2005 SP3, will this still be ok? Quote Share this post Link to post Share on other sites More sharing options...
jamitupya Posted June 10, 2010 Report post Posted June 10, 2010 Well, when I said upgrade, I'll be totally replacing the server and creating a new DB, and detaching/reattaching all the Primary Child sites to the new Central site. They are all running SQL2005 SP3, will this still be ok? Mmm... Maybe peter can answer this one... i've never done it this way. I assume that so long as the Central site DB is in tact, it shouldn't matter what version the lower level DB's are... again i've never looked ito this as we always maintain a standard build for our environments. i'd clone your central and a few primary sites into vm's and test it before hand.... Quote Share this post Link to post Share on other sites More sharing options...
MRaybone Posted June 10, 2010 Report post Posted June 10, 2010 Wish I had that luxury, I work for an organisation who can't imagine spending any money on something as 'insignificant' as a lab environment. Quote Share this post Link to post Share on other sites More sharing options...
jamitupya Posted June 10, 2010 Report post Posted June 10, 2010 oh goodie.... aah the bad 'ol days ok.... ummm do you have a MS EA or Support contract? (find the information prior to beginning). At this stage i would back out and talk to the powers that be, give them your recommendations see if you can swindle a white box server to test as this could nuke your environment and i guess they would see that as bad.... right? it took me 3days to recover from a DB corruption then failure and the issues associated so if your service desk supports the users this could void your SLA's and cause numerous headaches. I'm looking around a bit more... if i find anything more significant i'll pass it on...i suggest trawling technet.... Quote Share this post Link to post Share on other sites More sharing options...
kboy_16 Posted June 13, 2010 Report post Posted June 13, 2010 anyone can share a guide for configuring SCCM 2007 SP + SQL 2008 + Server 2008 SP2 please.. Thanks! Quote Share this post Link to post Share on other sites More sharing options...
jamitupya Posted June 13, 2010 Report post Posted June 13, 2010 kboy, use the guides sticky here.... mostly the same. very little difference between them. Quote Share this post Link to post Share on other sites More sharing options...
