none
Working with SQL Server FAQ: Bagaimana cara mencantumkan database tanpa file “.ldf”? RRS feed

  • Diskusi Umum

  • Jika ada file transaksi log yang hilang, kita dapat membangun kembali file log dengan pernyataan berikut:

    <div style="BORDER-BOTTOM: windowtext 1pt solid; BORDER- PADDING-BOTTOM: 1pt; PADDING- WIDTH: 600px; PADDING-RIGHT: 4pt; MARGIN- BORDER- BORDER-RIGHT: windowtext 1pt solid; PADDING->

    CREATE DATABASE [Test] ON (FILENAME = N'D:\Test.mdf') FOR ATTACH_REBUILD_LOG

    </div>

    Dokumentasi terkait:

    CREATE DATABASE (Transact-SQL)

    http://msdn.microsoft.com/en-us/library/ms176061.aspx


    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.



    Jumat, 04 Mei 2012 09.30
    Moderator