Following are the major steps to be taken to migrate/move sharepoint database from one SQL server to another SQL server:
1.Log into administration site (http://sharepointserver/default.aspx)
2.Click on the Operations tab and select perform a backup.
3.Select farm level backup and hit continue.
4.Enter destination of backup files and wait until finished backup.
5.Log onto the SharePoint server hosting the central administration.
6.Go to Start > Microsoft Office Server > SharePoint Product and Technologies Configuration Wizard.
7.Disconnect the server from the farm.
8.Repeat this step for the other web servers in the server farm if any.
9.Return to the first server and run the configuration wizard again, this time creating a new farm.
10.Enter data for the new database server (DBSERVER\Sharepoint) and create the farm.
11.Go to remaining web servers and join an existing farm using (DBSERVER\Sharepoint) for database.
12.Connect to administration site (http://sharepointserver/default.aspx)
13.Go to operations tab and select services on server.
14.Enable Office SharePoint Server Search
15.Enable Windows SharePoint Services Search Service (Leave default database information).
16.Go to Operations tab and perform a restore.
17.Select location of backup file and choose to restore the entire farm.
How to Migrate/move SharePoint Databases from One SQL Server to Another
Subscribe to:
Post Comments (Atom)
Popular Posts
-
I was trying to activate Windows Server 2008 and got this error: “Activation Error: Code 0x8007232b .DNS Name does not exist” Actually Windo...
-
I have a post paid connection from Vodafone and wanted to use their Rs.98 plan 2GB vodafone mobile connect plan on my iPhone 3GS ( ios 5.0.1...
-
As of now there is no Untethered jailbreak is available for iPhone 3GS with baseband 05.16.05. The only option is to upgrade the baseband fo...
-
To enable webclient service on server 2008 we need to install desktop experience feature. In earlier version of windows webclient service c...
-
We can store user pictures in AD using thumbnailPhoto attribute of AD user object. That picture can will be showing in Outlook 2010 contac...
-
You get following error when you PXE boot a client to deploy an OS image from ConfigMgr (PSP) : TFTP Download: smsboot\x64\abortpxe.com PXE...
-
I came across this error while installing SCCM client on a Windows 7 Machine. ccmsetup.log file was showing these errors: Failed to send H...
-
Issue: New Windows Update clients fail to install/sync the software updates from WSUS server WindowsUpdate.log file gives many errors refe...
-
I was trying to refresh Windows Experience Index on my computer and came across this error: “The Program can't start becuase MSVCR100.d...
-
I installed DAP on my computer to speed up my downloads and now whenever I open a new tab in IE or try to search something in search box...
No comments:
Post a Comment