It would be possible for you to recover the database if you have any previous backups, You can do the follwoing
Steps to recover your tables in the database, (Hope
you are using FULL Recovery Model)
Step 1 : Perform a transaction log backup in your current database
Backup log dbname to disk='drivename\txlog_final.bak'
Step 2 : Create a New Database
Step 3 : Restore the FULL database backup into a new database
Restore database Newdbname from disk='physicaldrive\filename.bak' with
move 'logical_data_filename' to 'new_data_physicalfile.mdf',
move 'logical_log_filename' to 'new_log_physicalfile.ldf',
Step 4 : Restore the subsequent TX log files in sequential order till the last
transaction log file in which log backup is taken
Restore log newdbname from disk='physicaldrive\txlogfile1.bak' with
Continue the step 4 for all transaction log files , but do not restore the last
transaction log file.
Step 5 : For the Last Transaction log file , use RECOVERY option
Restore log newdbname from disk='physicaldrive\txlog_final.bak' with
RECOVERY,STOPAT = 'Aug 12, 2008 07:30 PM'
This will revover the new database till 'Aug 12, 2008 07:30 PM'
Step 6 : Take the full backup of new db and restore into Current DB