Post reply

Attach MDF File With Ldf File Corrupted

  • May 20, 2010 at 1:48 am

    #221786

    Hi Dear DBA,

    I have problem on my database...

    you told before to generate mdb without ldf using sp_attach_single_file_db without ldf file, when i try it i have command like this

    "Could not open new database 'ikptTsMng_Data'. CREATE DATABASE is aborted.

    Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\ikptTimesheetManager_Log.LDF' may be incorrect."

    and it happen because my server broken by some virus that attack my system windows, n make me to recovery Windows App. but this influence to few of my DB file doesn't work, include this one.

    what should i do?

    btw, thank's before n after

  • May 20, 2010 at 2:21 am

    #1169928

    http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply