Out of memory exception in SQL Server Management Studio (SSMS) while opening ‘restore database’ page

Recently, my colleague came across a problem while trying to open the ‘Restore Database’ page in a SQL server database management tool , SSMS. Whether he right-clicked on the ‘Databases’ folder or on a specific database, the page wouldn’t open and eventually, he received an “out of memory” error message. Exception of type ‘System.OutOfMemoryException’ was … Read more