The first question that I have in mind before continuing this post is:
Q: Is it possible to have multiple instances for the same SharePoint farm?
A: Yes it is possible, we can have more than one SQL instance where we can store the content databases.
If you want to transfer a SharePoint content database from one instance to another you can use the following procedure:
On the SQL server1. Backup the content database.
2. Restore the database on the second instance 3. Add the same permissions for the content database that you had on the source instance. On the SharePoint Server 4. Detach the content database from the web application : stsadm.exe -o deletecontentdb -url <URL name> -databasename <database name> – additional information in the following article http://technet.microsoft.com/en-us/library/cc262449(v=office.12).aspx 5. Attach the content database from the new instance to your web application : stsadm.exe -o addcontentdb -url <URL name> -databasename <database name> -databaseserver <database server name> – Additional info in the following article http://technet.microsoft.com/en-us/library/cc263422(v=office.12).aspx Additional information regarding backup restore procedure in the following article http://technet.microsoft.com/en-us/library/cc671616(v=office.12).aspx Back up and restore databases (Office SharePoint Server) |
Second question, is it possible to have the instances on different SQL versions?
Yes it is, but you need to check the compatibility of the SharePoint product with the SQL version.
Here you have a table with the compatibility between different SharePoint versions and SQL
SharePoint 2007
OK | KO |
· SQL Server 2008. You must install Windows SharePoint Services 3.0 SP1 or later in order to use SQL Server 2008. · SQL Server 2008 R2. Ensure that you have installed Windows SharePoint Services 3.0 with Service Pack 2 (SP2) or later. | · SQL Server 2012 or later versions of SQL Server. |
SharePoint 2010
OK | KO |
· The 64-bit edition of Microsoft SQL Server 2005 with Service Pack 3 (SP3). · The 64-bit edition of Microsoft SQL Server 2008 with Service Pack 1 (SP1) and Cumulative Update 2· The 64-bit edition of Microsoft SQL Server 2008 R2.· The 64-bit edition of Microsoft SQL Server 2012. You must also be running SharePoint Server 2010 SP1 or a later version of SharePoint Server 2010. | · All the 32-bit editions and all the SQL versions earlier than SQL 2005 SP3 |
SharePoint 2013
OK | KO |
· The 64-bit edition of Microsoft SQL Server 2012.· The 64-bit edition of SQL Server 2008 R2 Service Pack 1 | · All the 32-bit editions and all the SQL versions earlier than SQL Server 2008 R2 Service Pack 1 |
Thank you for reading this post.
Source of this article:
http://technet.microsoft.com/en-us/library/cc288751(v=office.12).aspx Determine hardware and software requirements (Windows SharePoint Services)
http://technet.microsoft.com/en-us/library/cc262485(v=office.14).aspx Hardware and software requirements (SharePoint Server 2010)
http://technet.microsoft.com/en-us/library/cc262485.aspx Hardware and software requirements for SharePoint 2013
Pingback: Change web application's content database | DL-UAT