How to recover the deleted database using transaction log file?

45 pts.
Tags:
Data Recovery
SQL Log Files
SQL Server
SQL Server transaction logs
Windows
Windows Server
Windows Server 2003
Windows Server 2003 Backup
Hello all u witty people!
I am working for a pvt. corporate company. We are using Windows 2003Server as our OS and SQL Server. Earlier this morning, i was taking the back up and as my hard disk ran out of space, so it showed me an error message stating that there was not much space. but by then, my transaction log file was successfully copied to hard disk and my database file was interrupted. So while deleting my hard disk files, I made a mistake and deleted the main database for my server. Now I have the log file and the half copied database file with me in my hard disk. Can i restore back my database using that log file and that half copied database file? Please help me out guys.
Thank you.
Regards,


Software/Hardware used:
Sql Server and Windows 2003Server

Answer Wiki

Thanks. We'll let you know when a new response is added.

Log file could not be used to backup the entire database of your computer server. Since it is just a log file, you can only see the logs of the activities done in your computer system like installing, editing, adding, deleting, etc.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    No. Without a database backup there is no way to recover the database.
    66,065 pointsBadges:
    report
  • Kalyan200887
    There's a site out there on web stating that they'll restore backup from any point. I mailed them yesterday and waiting for them to reply me back. This is their site address. http://www.ontrackdatarecovery.com. If I find anything interesting I'll surely let you guys know about it. By the way, Thank you very much for your advice. :)
    45 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following