Home Forums SQL Server 7,2000 Administration Restore Database to new SQL Server from backup RE: Restore Database to new SQL Server from backup

  • December 21, 2004 at 2:27 pm

    #534678

    and to add to Osoba you will need also ,REPLACE if the files exists

    RESTORE DATABASE MyNwind   FROM MyNwind_1   WITH NORECOVERY
    ,       MOVE 'MyNwind' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.mdf'
    ,       MOVE 'MyNwindLog1' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.ldf'
    , REPLACE
    RESTORE LOG MyNwind   FROM MyNwindLog1   WITH RECOVERY

     


    * Noel