SharePoint 2010: The list is too large to save as a template

Problem

You attempt to save a list as a template, including its data, and you are presented with this error:
 

Solution

1. Increase the MaxTemplateDocumentSize property using either PowerShell or stsadm.  Default is 50 MB.  Maximum is 500 MB.
2. Using PowerShell:
1. Execute the following commands in a PowerShell command window to increase the maximum to 500 MB:

   [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
   [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Administration")
   $docSize = 500000000
   $webservice = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
   $webservice.MaxTemplateDocumentSize = $docSize
   $webservice.Update()
   

   

3. Using stsadm:
1. Run the following command at the command prompt:

   stsadm -o setproperty -propertyname max-template-document-size -propertyvalue 500000000

Notes

• The PowerShell commands can be executed on any server in the SharePoint farm.  Note that if you use
• stsadm can be executed in the command window on any SharePoint server in the SharePoint farm.  If you experience an error trying to execute stsadm, check the DOS Path environment variable to be sure that it includes the path to the stsadm binary, which, by default for 2010, is located here:

  C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\BIN 

References

• System.Reflection Namespace
• Assembly Class
• Assembly.LoadWithPartialName Method
• Microsoft.SharePoint namespace
• Microsoft.SharePoint.Administration namespace
• SPWebService class
• SPWebService.ContentService property
• SPWebService.MaxTemplateDocumentSize property
• Increase maximum size of List Template
• How to use Powershell to set Max template document size
• Tip: Quickly Import List and Library Templates into SharePoint