The SharePoint Knowledge Collection of Cornelius J. van Dyk, an 9 x SharePoint MVP
17 August 2010
How do I – Move my SharePoint databases from a 32 bit Windows Server 2003 x86 with SQL Server 2005 x86 to a new SQL instance on a 64 bit Windows Server 2008 R2 x64 with SQL Server 2008 R2 x64
As part the migration plan for a major customer of mine, we had a phase scheduled to move the back end databases from 32 bit Windows Server 2003/SQL Server 2005 to 64 bit Windows Server 2008 R2/SQL Server 2008 R2. This brought back to light the question of how to move your content to a new SQL Server. There are many good articles out there, but this worked well for us.
http://www.cjvandyk.com/blog/Articles/How-do-I—Move-my-SharePoint-databases-from-32-bit-SQL-Server-2005-x86-to-a-new-Instance-on-64-bit-SQL-Server-2008-R2-x64.aspx
Cheers
C
Subscribe to:
Post Comments (Atom)
SharePoint Remote Event Receivers are DEAD!!!
Well, the time has finally come. It was evident when Microsoft started pushing everyone to WebHooks, but this FAQ and related announcement...
-
Ever wondered what the new SharePoint Online URLs are all about? Take for example https://cjvandyk.sharepoint.us/:x:/r/sites/Site1... What ...
-
Every so often, you run across the need to redirect a page somewhere else, like after a server migration when DNS isn’t used. By simply addi...
-
When using NuGet, we can easily run into assembly reference issues. A notorious error message is: CS0012: The type ‘System.Object’ is def...
No comments:
Post a Comment
Comments are moderated only for the purpose of keeping pesky spammers at bay.