Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Hai

Answered Hai

  • Monday, February 18, 2013 2:08 AM
     
     
    Sign In to Vote
    0
    My 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?
     

All Replies

  • Monday, February 18, 2013 6:24 AM
     
     Answered
    Sign In to Vote
    0

    Hi,

    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

    MyBlog

    • Marked As Answer by rajkat85 Tuesday, February 26, 2013 2:21 AM
    •  
     
  • Monday, February 18, 2013 2:40 PM
     
     Answered
    Sign In to Vote
    0

    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.

    Thomas

    TheSmilingDBA Thomas LeBlanc MCITP 2008 DBA

    • Proposed As Answer by TheSmilingDBA Monday, February 18, 2013 2:40 PM
    • Marked As Answer by rajkat85 Tuesday, February 26, 2013 2:21 AM
    •