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.
Software/Hardware used: Sql Server and Windows 2003Server
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!