Anmelden
 
HomeLibraryDownloadsSupportWebcasts & EventsCommunityForenBlogs
Ressourcen für IT-Professionals >
> 
> 
Hai

답변됨 Hai

  • Montag, 18. Februar 2013 02:08
     
     
    Anmelden
    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?
     

Alle Antworten

  • Montag, 18. Februar 2013 06:24
     
     Beantwortet
    Anmelden
    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

    • Als Antwort markiert rajkat85 Dienstag, 26. Februar 2013 02:21
    •  
     
  • Montag, 18. Februar 2013 14:40
     
     Beantwortet
    Anmelden
    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

    • Als Antwort vorgeschlagen TheSmilingDBA Montag, 18. Februar 2013 14:40
    • Als Antwort markiert rajkat85 Dienstag, 26. Februar 2013 02:21
    •