Move an SSP to another farm
Problems (and Solutions)
Access Denied when accessing SSP Admin Site
Access Denied! Only site admin can access Data Source object from user profile DB
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
Unable to Delete Shared Services
Mysite is unavailable – 404 error
stsadm -o backup gives error 5
stsadm -o restore gives The server principal x is not able to access the database x under the current security context
PDF Icon is Missing
Configure Mysites to appear under http://portal/personal/
Sharepoint does not like filenames to contain certain characters:
Joel is a reputable source, with an exhaustive review:
The official microsoft reference is:
LDAP Filter for user profile import
The marketing site – http://sharepoint.microsoft.com
Restoring SSP using stsadm -o restore
The server principal x is not able to access the database x under the current security context.
Solution: The user who is performing the restore (i.e. who is logged into the desktop) needs to be a member of the sysadmin role on the sql server.
Best Practice on Backups
Export User Profiles
This one only works if you have a fully working Shared Services Provider
stsadm -o deletesite gives (Exception from HRESULT: 0x80070003)
So someone accidentally deleted a site collection (/sites/banana). I attempted to stsadm -o restore but got scared and cancelled it with Ctrl+C. Bizarrely, the site collection (/sites/banana) is still shown in the Central Administration Site Collection List, but without any information in the right hand panel.Presumably the database is corrupt in some way.
I want to delete the site collection so stsadm -o deletesite -url http://intranet/sites/banana but it says Exception from HRESULT: 0x80070003)
A quick google for Exception from HRESULT: 0x80070003) gives:
The Technet reference for databaserepair: http://technet.microsoft.com/en-us/library/cc288636.aspx
So lets see what sites are orphaned: stsadm -o databaserepair -url http://intranet/sites/banana -databasename wss_content_banana
Lets delete the orphaned sites: stsadm -o databaserepair -url http://intranet/sites/banana -databasename wss_content_banana -deletecorruption
But that doesn’t work.
Lets try detaching and reattaching the content database.
This strategy is backed up by:
stsadm -o preparetomove -contentdb wss_content_banana -site http://intranet/sites/banana
And remove database from farm:
stsadm -o deletecontentdb -url http://intranet/sites/banana -databaseserver wss_content_banana -databasename wss_content_banana
When you’re ready to reattach your database to the farm follow this only step:
stsadm -o addcontentdb -url http://intranet/sites/banana -databaseserver sqlserver1 -databasename wss_content_banana
Move a Sharepoint Site
Move a Sharepoint Document Library and Preserve Metadata
There are two inferior methods for copying data between document libraries or lists:
Using the explorer view to copy items from one tother
Creating list or library templates
These methods are inferior as they do not preserve the ‘Created By’, ‘Last Modified By’, etc. metadata.
Here is a method for moving the data whilst preserving its metadata:
Create a blank list or library as the destination
Goto the ‘Site Content and Structure’ page
Navigate to the source list or library
Select every item in the source list or library
Actions -> Move
Select your destination list or library
Henry also uses this technique:
stsadm -o backup gives Error 5
Your UNC backup folder needs to be SHARED and sharepoint service, central admin apid, sql server service need to have read/write on that share.