Monday, February 18, 2013 2:08 AMMy database log file is completely got corrupted/ deleted i have only one .mdf file .can i recover the database ,if so how do we recover?
Monday, February 18, 2013 6:24 AM
you can use your last full backup and restore it may be with replace option to replace the log and data file.
I hope this is helpful.
Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
MCSE Data Platform
MCITP: SQL Server 2008 Administration/Development
MCSA SQL Server 2012
MCTS: SQL Server Administration/Development
- Marked As Answer by rajkat85 Tuesday, February 26, 2013 2:21 AM
Monday, February 18, 2013 2:40 PM
You can also attach a mdf file without a ldf file and SQL Server will re-create a new Log file.
1. Shutdown instance
2. Copy mdf file to new location
3. start instance
4. Attach database with copied mdf file with a new database name or on a different instance
new file created.
TheSmilingDBA Thomas LeBlanc MCITP 2008 DBA