There are a number of things to consider before running an Externalize or Recall job:
1.While it is not required, we strongly recommend that Externalize and Recall operations be preformed during operational windows where users and other bulk processes are not using the same system resources and/or accessing the same content.
2.We strongly recommend that Indexes are rebuilt and Statistics are updated on each content database that will participate in a Externalize or Recall job execution.
3.We strongly recommend that there is a recent backup of the content database and in the case of a Recall job, the BLOB store as well.
4.We recommend setting the Recovery mode on the SharePoint Content database to Simple before running any jobs. Please go for more information on Recovery Modes. If Recovery Mode is not switched to Simple, please make sure there is enough available disk space to handle the growth of the Content databases associated transaction log.
There are several steps we would strongly recommend running after an Externalize or Recall job is complete:
Post-Externalize Job (performed on each content database individually):
1.DBCC_SHRINKDATABASE (may have to execute this step multiple times to fully reclaim unused space)
2.Reorganize or Rebuild indexes
3.Update statistics (should be done after the indexes are rebuilt)
Post-Recall Job (performed on each content database individually):
1.Reorganize or Rebuild indexes
2.Update statistics (should be done after the indexes are rebuilt)
For more information on general best practices on maintaining SQL for SharePoint please download and read thewhitepaper.
This section is only relevant for existing content databases. Once Metalogix StoragePoint is installed and configured, new and updated content will be externalized in real-time.
A database can be shrunk inor to reclaim the empty space left over after the content BLOBs have been removed from the database. This operation may have to be performed as many as 3 times. This is primarily due to the large amount of table fragmentation post-Externalize.