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 ...
-
When using NuGet, we can easily run into assembly reference issues. A notorious error message is: CS0012: The type ‘System.Object’ is def...
-
Have you ever started creating a list view in SharePoint and because you're experimenting, you chose to make it a "Private" vi...
No comments:
Post a Comment
Comments are moderated only for the purpose of keeping pesky spammers at bay.