Answer to "Is it Possible to repair Transcend Pendrive?"Have a look at this link http://www.repaircrashed.com/pen-drive/ it will show you step by step method to fix pen drive is not recognizing error.
Answer to "How to fix SQL database?"Execute the following query ALTER DATABASE test SET emergency GO ALTER DATABASE test SET single_user GO DBCC checkdb (test, repair_allow_data_loss) ALTER DATABASE test SET multi_user GO BUT be careful: REPAIR_ALLOW_DATA_LOSS means that some data might be lost in the DB even if it attached successfully. If you want to recover your data without any loss then you must go with third party SQL MDF Recovery Tool