Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Kehayias Moving Database Files Detach/Attach or ALTER DATABASE? RE: Moving Database Files Detach/Attach or ALTER DATABASE?

  • September 24, 2010 at 10:39 am

    #1227116

    Nils Gustav Stråbø (9/24/2010)

    So if you delete the transaction log file and the database was not shut down properly there is no chance in h*** you can attach the database again.

    Or am I missing something? Not that I would ever do something like that.

    It won't attach, but there are ways to (in most cases) get it back.

    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