SQl Database back showing error "Exception of type "System.OutofMemoryException" was thrown.(mscorlib)"

Vote count:

0

I need to take a backup of a SQL database with data. I select Tasks -> Generate Scripts... -> Next -> Next and in Table view option I changed Script Data FALSE to TRUE -> Next -> Select all -> Script to New Query Window -> Finish. But it end up with an error "Exception of type "System.OutofMemoryException" was thrown.(mscorlib)". I have checked the memory space of my drives. C drive is having more than 10 GB and D drive is having more than 3 GB but the database is only 500MB. That error is showing for 1 particular table "TBL_SUMM_MENUOPTION" which is an empty table. May I know how to fix this issue? How to take that database backup with out this error?

Screenshot for better understanding:

asked 33 secs ago

Sathiya Kumar

138

SQl Database back showing error "Exception of type "System.OutofMemoryException" was thrown.(mscorlib)"