Sunday 6 July 2014

Restoring and upgrading the Content on the SharePoint 2010 Farm

First take the backup of Sharepoint 2007 content database.
Copy the back up of your SharePoint 2007 content database in the right folder to restore.
Steps:
1.Create a new Web Application on your SharePoint 2010 farm to host the content database to be restored.
Note down database name and database server name while creating Web application.
2.Open SQL Server Management Studio.
Start-->All Programs-->Microsoft SQL Server 2008-->SQL Server Management Studio.
3.Open Database which you noted in step 1.
4.Right click on database-->Tasks-->Restore-->Database.
5.Now window will open
In General tab: Select "From Device" as a source for restore.
Click on ... button.
Click on "Add", to go to backup location.
Select database .bak which we have taken from sharepoint 2007.
Click on the "Options" tab.
Select overwrite the existing database.
Click ok.
Note: Grant the db_owner permissions to the Set-up account the which you will be logged-in with when you will perform the upgrade for the new database, otherwise the upgrade will definitively fail!
We have restored Database in Sharepoint 2010 Database.
6.Open a command prompt on a SharePoint 2010 server that hosts the SharePoint 2010 central Administration and type the following command:
stsadm -o addcontentdb -url yourWebApplicationUrl -databasename yourDatabasename -databaseserver yourdatabaseServerName
ex: stsadm -o addcontentdb -url http://FAREAST:9111/ -databasename WSS_1 –databaseserver MICROSOFT001.
If you open Central Administration Web site in SharePoint 2010 we can watch automatically giving you the number of warnings and errors encountered during the upgrade process, and informing you about the site that is involved by the upgrade process.
Restart upgrade for a database by using Windows PowerShell
At the Windows PowerShell command prompt (PS C:\>), type the following command:
upgrade-spcontentdatabase -id
Where GUID is the identifier for the database. You can run the following cmdlet to find the GUID for a content database:
Get-SPContentDatabase -Identity
Restart upgrade for a server farm by using Psconfig.exe
If you determine that upgrade stopped or failed before the SharePoint Products Configuration Wizard was completed, you can restart the upgrade from that point by running the SharePoint Products Configuration Wizard again or by using a command line operation. This process is also known as forcing a software upgrade. Be sure to research and address the problem that caused the failure or stoppage before you restart upgrade.
To restart upgrade for the server farm
Verify that you have the following administrative credentials:
• To use Psconfig.exe, you must be a member of the local Administrators group on the server.
Open a Command Prompt window and navigate to the following directory:
%COMMONPROGRAMFILES%\Microsoft shared\Web server extensions\14\Bin\
Type the following command:
psconfig -cmd upgrade -inplace v2v -passphrase -wait
There is an optional parameter, -force, that can force the upgrade to continue if the command does not work. Add -force to the end of the command string to force the upgrade process to continue.
Once the upgrade process has been completed, you can review the upgrade log.
While there are some errors the Status will be "Failed", but it does not mean that your SharePoint site will not be available. For example, assume you have provisioned some files or a list by using a feature and that someone has removed the files or the list from the SharePoint site and removed the feature from the file system of the source farm without uninstalling it.
Your upgrade will be successful since the pages provisioned are no more required, but the reference of the feature is still in the SharePoint content database, and while the upgrade process does not find the feature in your SharePoint 2010 file system you will have an error and the upgrade will be set to "Failed", but you will be able to perfectly use all the functionalities of your upgraded SharePoint 2010 site.
And have a content database perfectly restored
That's it your new site got up!!!!!!
Now you can do Visual Upgrade.
Click on Site Actions-->visual upgrade
Select "Preview the updated user interface"
Your new sharepoint 2010 site has created.......enjoy!!!!!!!!!!!!!