Upgrade Database Server to SqlServer 2008
I have MOSS 2007 on a server and the DB's are SqlServer 2005 DB's and they reside on the same server as the MOSS 2007.
I want to switch my DB's to a SqlServer 2008 DB that is separate from the MOSS server.
Anyone know how this can be achieved?
November 22nd, 2010 9:09am
Backup DBs from 2005 SQL server and then restore it on SQL 2008 server
After that disconnect SharePoinr from SQL 2005 and create a new configuration DB on SQL 2008 by connecting SharePoint to new SQL server. (SQL 2008 )
Once you will get Central admin up and running create sites and attach old DBs which you have restored on SQL 2008 from SQL 2005.
Regards, Pratik Vyas | SharePoint Consultant |
Free Windows Admin Tool Kit Click here and download it now
November 22nd, 2010 9:52am
Thanks for the reply Pratik.
But how do you do this bit you describe:
After that disconnect SharePoinr from SQL 2005 and create a new configuration DB on SQL 2008 by connecting SharePoint to new SQL server. (SQL 2008 )
Thanks J.
November 22nd, 2010 10:29am
Hi JMcCon,
All the necessary steps to move all databases to a new SQL Server are detailled in this article :
http://technet.microsoft.com/en-us/library/cc512725(office.12).aspx
Hope it helps you, MarioMon Blog/My Blog (in french)
LinkedIn
Free Windows Admin Tool Kit Click here and download it now
November 22nd, 2010 1:26pm
Hi JMcCon,
All the necessary steps to move all databases to a new SQL Server are detailled in this article :
http://technet.microsoft.com/en-us/library/cc512725(office.12).aspx
Hope it helps you, MarioMon Blog/My Blog (in french)
LinkedIn
November 22nd, 2010 1:26pm
Backup DBs from 2005 SQL server and then restore it on SQL 2008 server
After that disconnect SharePoinr from SQL 2005 and create a new configuration DB on SQL 2008 by connecting SharePoint to new SQL server. (SQL 2008 )
Once you will get Central admin up and running create sites and attach old DBs which you have restored on SQL 2008 from SQL 2005.
Regards, Pratik Vyas | SharePoint Consultant |
Free Windows Admin Tool Kit Click here and download it now
November 22nd, 2010 5:48pm
Thanks for the reply Pratik.
But how do you do this bit you describe:
After that disconnect SharePoinr from SQL 2005 and create a new configuration DB on SQL 2008 by connecting SharePoint to new SQL server. (SQL 2008 )
Thanks J.
by running SharePoint Products and Technology wizard, select create a new configuration DB and provfide name of new SQL 2008 server
Regards, Pratik Vyas | SharePoint Consultant |
November 23rd, 2010 4:02am
Thanks Mario.
J.
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2010 6:32am
Thanks Pratik.
J.
November 23rd, 2010 6:32am
Thanks for the reply Pratik.
But how do you do this bit you describe:
After that disconnect SharePoinr from SQL 2005 and create a new configuration DB on SQL 2008 by connecting SharePoint to new SQL server. (SQL 2008 )
Thanks J.
by running SharePoint Products and Technology wizard, select create a new configuration DB and provfide name of new SQL 2008 server
Regards, Pratik Vyas | SharePoint Consultant |
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2010 11:58am