Aug 13, 2009

Restaurar Sharepoint

Here are several ways to backup and restore (or move) a Sharepoint installation, from the least to most difficult:

  1. stsadm -o export will export a site or subsite (-includeusersecurity will preserve all security roles and permissions).
  2. stsadm -o backup will backup an entire site collection
  3. stsadm -o backup -backupmethod complete will backup an entire farm
When importing a site, the user must be a site collection administrator.
When restoring (and especially moving) an entire farm with new users or to a new domain, Sharepoint will usually not assign correctly the permissions in SQL Server databases to the new service accounts. The user must revise all the Security User assignments in every database related to Sharepoint and add any service accounts that should be db_owner.