9 декабря 2010 г. 17:46
Can someone tell me the correct upgrade/migration path for the following:
We have a SQL 2008 R1 server with SharePoint 2010 Content databases on hardware that needs replacing, so we are purchasing a new server and will install SQL 2008 R2 on the server.
We will need to configure the new SQL 2008 R2 server to connect to our SharePoint 2010 server, and we will need to migrate our current R1 databases over to the new R2 server.
If anyone can advise on the easiest way to accomplish this, I would appreciate it.
10 декабря 2010 г. 13:19
and we will need to migrate our current R1 databases over to the new R2 server.
In a nutshell, you have to backup the database on R1, copy over the backup file, restore the database on R2. Server accounts/db users must be configured similarly to R1.
Related BOL links:
Kalman Toth, SQL Server & Business Intelligence Training; SQL Server 2008 Training
- Помечено в качестве ответа SteveMcC1 11 декабря 2010 г. 2:37
11 декабря 2010 г. 2:38Thanks, Kalman. I was hoping it would be that straightforward.
29 декабря 2012 г. 0:53
We have Sharepoint 2010 with SQL Server R1, so we got new server having SQL 2008 R2, so we plan to migrate our sharepoint Config, Content,Profile,Sync,BDC to new SQL server of R2 and point to Sharepoint 2010 to new SQL server.
We are looking Proc & cons for this migration and any sharepoint patch required to point New SQL version. Please guide me