syntaxhelp.com Your online cheat sheet!

Restoring the FULL Backup on Mirror Server (If paths are Identical)

-- Database Name: Adventure Works
-- Backup File Name: c:\AdventureWorks.bak

RESTORE DATABASE AdventureWorks 
    FROM DISK = 'C:\AdventureWorks.bak' 
    WITH NORECOVERY
GO

Restoring the FULL Backup on Mirror Server (if paths are different)

-- Database Name: Adventure Works
-- Backup File Name: c:\AdventureWorks.bak
-- Data File Path: c:\data
-- Log File Path: c:\log

RESTORE DATABASE AdventureWorks
   FROM DISK='C:\AdventureWorks.bak'
   WITH NORECOVERY, 
      MOVE 'AdventureWorks_Data' TO 
         'c:\data\AdventureWorks_Data.mdf', 
      MOVE 'AdventureWorks_Log' TO
         'c:\log\AdventureWorks_Log.ldf';
GO

Restoring the Transaction Log Backup on the Mirror Server

-- Database Name: AdventureWorks
-- File Name: c:\adventureworks.trn

RESTORE LOG AdventureWorks 
    FROM DISK = 'C:\AdventureWorks.trn' 
    WITH FILE=1, NORECOVERY
GO