--Using a shared drive in a server

--Initial Instance

BACKUP DATABASE [Database1] TO DISK = N'\\share\Backups\Database1_20140417-0100.bak'

WITH NOFORMAT, NOINIT, NAME = N'Database1s-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10;

--Destination Instance

RESTORE DATABASE [Database1]

FROM DISK = N'\\share\Backups\Database1_20140417-0100.bak' WITH FILE = 1,

MOVE N'Database1_Data' TO N'D:\DataFiles\Database1_Data.mdf',

MOVE N'Database1_Log' TO N'E:\LogFiles\Database1_Log.ldf', NOUNLOAD, STATS = 10