Export a smaller number of records to reduce the amount of memory used on the server.
Establish upper and lower limits to the amount of memory used by the SQL Server database engine. Refer to the Microsoft article
319942 for instructions.
Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist in implementing the solutions on these websites.