Home Forums SQL Server 2005 SQL Server 2005 General Discussion sql 2005, mdf restoration, w/out ldf, new box RE: sql 2005, mdf restoration, w/out ldf, new box

  • February 8, 2008 at 4:14 pm

    #776649

    use sp_attach_single_file_db to attach only the mdf file to the database server so that a new ldf file is created once the mdf is attached.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com