How to recover SQL XML data type documents? For this type of trouble we recommend you to use SQL XML recovery software which has much and more capabilities to recover corrupt SQL MDF file’s XML data types, tables, triggers, stored procedure etc. If you table got deleted accidentally then you can recover it with the help of this software.