Thursday, July 26, 2012

Major differences between STSADM Export/Import and Backup/Restore operations



Both these commands are primarily designed to back up data. But they work differently.
Based on your need, you can use either one of them.

stsadm –o backup/restore

With the URL and filename parameters, it allows you to backup either a site collection or web application. We can basically consider the file generated as a SQL dump of your content database.

Backup/Restore preserves the GUID of every object except the GUID of the Site: when you restore the backup, SharePoint generates a new GUID for the site collection.
This was done on purpose, because Sites table in configuration database uses SiteID as the primary key.

This is very important because it allows you to restore the backup in the same farm in which you did the backup. You can even restore the same backup in the same farm as many times as you want, but we should always restore it in a different content database, since the GUID of all other object remains unchanged. This operation is designed to take an exact copy of a site collection; no data will be changed, transformed or lost.


stsadm –o export/import

This is the only standard operation that allows you to backup data of a sub site, but it can also export a site collection, an entire web application, or a single list. It generates a new GUID for every object - sites, sub sites, lists and items.

Another difference is that you can restore the content in an existing site; the behavior with existing data is defined with the parameter update versions in import operation.
A major drawback of this operation is that it does not preserve workflows instances, associations, history and tasks. Every workflow association must be recreated and there is no way to restore the running instances from original site.
Contrary to the backup operation, it does not matter on which content database you run import operation, and you can restore a top site as a subsite, and reciprocally (except for sites with publishing feature where it is not supported: http://blogs.technet.com/b/stefan_gossner/archive/2009/05/27/limitations-of-stsadm-o-export-import-related-to-publishing-sites.aspx).

This operation is good for merging content of sites, and to decide how to handle identical data between source and target. Very important, do not forget to use includeusersecurity parameter in both export and import if you wish to preserve information relative to permissions and other properties such as documents authors.

Tuesday, July 17, 2012

Error while editing an Office Document in Sharepoint

                        These are some of the error messages Sharepoint users come across when they try to edit/check out a document uploaded in Sharepoint using Microsoft Word.


---------------------------
Message from webpage
---------------------------
'Edit Document' requires a Windows SharePoint Services-compatible application and Microsoft Internet Explorer 6.0 or greater.
---------------------------
OK  
---------------------------

---------------------------
Message from webpage
---------------------------
The document could not be opened for editing.  A Microsoft SharePoint Foundation compatible application could not be found to edit the document.
---------------------------
OK  
---------------------------



The below KB article should fix the issue.


1) Run the Fix it (Microsoft Fix it 50667) solution ->Close All the browsers.

2) Open a new browser session. Browser ->Tools ->Manage Add-Ons



3) Go to Toolbars and Extensions -> Sharepoint OpenDocuments Class -> Enable this.





If you don’t want to run the Fix It solution , follow the below steps and then carry out steps 2 and 3 as given above

Let me fix it myself


Note For Office 2003 and Office 2007 an error occurs in steps 4 and 6. This error is benign and the appropriate modifications have occurred. The error message reads similarly to: "DllRegisterServer in C:\Program Files\Microsoft Office\OFFICE11OWSSUPP.DLL failed. Return code was: 0x80070716.

1) Click Start, and then click Run.

2) In the Open box, type cmd, and then click OK.

3) By default, the Owssupp.dll file is located in one the following folders, as appropriate for your version of Office:

If Office XP is installed on the computer: Drive:\Program Files\Microsoft Office\Office10
If Office 2003 is installed on the computer: Drive:\Program Files\Microsoft Office\Office11
If the 2007 Office suite is installed on the computer: Drive:\Program Files\Microsoft Office\Office12

4) Type the following line, and then press ENTER:
regsvr32 -u owssupp.dll

5) Click OK when you receive the message that states that the operation was successful.

6) Type the following line, and then press ENTER:
regsvr32 owssupp.dll

7) Click OK when you receive the message that states that the operation was successful.

8) Type exit to exit Command Prompt.

Wednesday, July 11, 2012

SharePoint 2010 Build / Version Numbers


To check  the build/version details of the farm :

Browse to Central Administration > System Settings > Manage servers in your farm (/_admin/FarmServers.aspx)

Windows PowerShell: (get-spfarm).buildversion

To check the build/version detail of the products :

Browse to Central Administration > Upgrade and Migration > Check Product and patch installation status (/_admin/PatchStatus.aspx)

To check the build/version detail of the databases :

Browse to Central Administration > Upgrade and Migration > Review database status (/_admin/DatabaseStatus.aspx)



P.S. Also refer to the below link for all versions of Sharepoint

SPS 2001   |    STS 2002    |   SPS 2003    |   MOSS 2007     |   Sharepoint 2010





Build
Release
Component
​Information
Download Link
Notes
14.0.4763.1000
RTM
All components
14.0.4762.1000
RTM
Farm Build Version





14.0.5114.5003
June 2010 CU
SharePoint Foundation 2010
14.0.5114.5003
June 2010 CU
Microsoft Shared Components
14.0.5114.5003
June 2010 CU
Microsoft SharePoint Portal
14.0.5114.5003
June 2010 CU
Microsoft User Profiles
14.0.5114.5003
June 2010 CU
Microsoft Search Server 2010 Core
14.0.5114.5003
June 2010 CU
Microsoft Web Analytics Web Front End Components
 
  
  
  
14.0.5123.5000
August 2010 CU
SharePoint Foundation​ 2010
14.0.5123.5000
August 2010 CU
SharePoint Server 2010




14.0.5128.5000
October 2010 CU​
SharePoint Foundation​ 2010
14.0.5128.5000​
October 2010 CU​
SharePoint Server 2010​
14.0.5130.5002​
​December 2010 CU
SharePoint Foundation 2010
14.0.5130.5002​
December 2010 CU​
SharePoint Server 2010​
14.0.5136.5002​
February 2011 CU​
SharePoint Foundation 2010
14.0.5136.5002​
February 2011 CU​
SharePoint Server 2010​
14.0.5138.5000
​April 2011 CU
​SharePoint Foundation 2010
14.0.5138.5000
​April 2011 CU
SharePoint Server 2010​
14.0.5138.5000
​April 2011 CU
​Project Server 2010
​14.0.6029.1000
​Service Pack 1
​SharePoint Server 2010​
​14.0.6029.1000
​Service Pack 1
​Office Web Apps
​​14.0.6029.1000
​Service Pack 1
​Project Server 2010
​14.0.6029.1000
​Service Pack 1
​SharePoint Foundation 2010
14.0.6029.1000
​Service Pack 1
​FAST Search Server
​14.0.6105.5000
​June 2011 CU Mark 1
​​SharePoint Server 2010​
​14.0.6105.5000
​June 2011 CU Mark 1
​SharePoint Foundation 2010
​14.0.6105.5000
​​June 2011 CU Mark 1
​Project Server 2010
​14.0.6106.5002
​​June 2011 CU Mark 2
​​​SharePoint Server 2010​
​14.0.6106.5002
​​June 2011 CU Mark 2
​SharePoint Foundation 2010
​14.0.6106.5002
​​June 2011 CU Mark 2
​Project Server 2010
14.0.6105.5000
​June 2011 CU
​Office Web Apps
14.0.6109.5002
​August 2011 CU
​SharePoint Server 2010
14.0.6109.5000
​August 2011 CU
​​SharePoint Foundation 2010
14.0.6109.5000
​August 2011 CU
​Project Server 2010
14.0.6109.5000
​August 2011 CU
​FAST Search Server
14.0.6112.5000
​October 2011 CU
​SharePoint Server 2010
14.0.6112.5000
​​October 2011 CU
​​​SharePoint Foundation 2010
14.0.6112.5000
​​October 2011 CU
​​Project Server 2010
14.0.6114.5000
December 2011 CU
​SharePoint Server 2010
14.0.6114.5000
December 2011 CU
​SharePoint Foundation 2010
14.0.6114.5000
December 2011 CU
​Project Server 2010
14.0.6117.5002 ​
February 2012 CU​
SharePoint Server 2010​
14.0.6117.5002 ​
February 2012 CU​
SharePoint Foundation 2010​
14.0.6117.5002 ​
February 2012 CU​
Project Server 2010​
14.0.6117.5002 ​​
February 2012 CU​
Office Web Apps​
14.0.6117.5002
​February 2012 CU​
​FAST Search Server
14.0.6120.5000
April 2012 CU​ Mark1
​​SharePoint Server 2010
​Removed
14.0.6120.5000
​April 2012 CU​ Mark1
​SharePoint Foundation 2010​
​Removed
14.0.6120.5000
​April 2012 CU​ Mark1
​Project Server 2010
​Removed
14.0.6120.5000
​​April 2012 CU​
​​FAST Search Server
14.0.6120.5006
​April 2012 CU​ Mark 2
​SharePoint Server 2010​
​​Download
14.0.6120.5006
​April 2012 CU​ Mark 2
​SharePoint Foundation 2010​
14.0.6120.5006
​April 2012 CU​ Mark 2
​Project Server 2010
​​Download
14.0.6123.5002
​June 2012 CU
​SharePoint Server 2010​
14.0.6123.5002
​​June 2012 CU
​SharePoint Foundation 2010​
14.0.6123.5002
​​June 2012 CU
​Office Web Apps​
14.0.6123.5002
​June 2012 CU
​Project Server 2010