sample1:
BACKUP DATABASE AdventureWorks 
   TO DISK = 'C:\AdventureWorks.bak'

RESTORE FILELISTONLY 
   FROM DISK = 'C:\AdventureWorks.bak'

RESTORE DATABASE TestDB 
   FROM DISK = 'C:\AdventureWorks.bak'
   WITH MOVE 'AdventureWorks_Data' TO 'C:\testdb.mdf',
   MOVE 'AdventureWorks_Log' TO 'C:\testdb.ldf'
GO


sample2:
-- Create a logical backup device for data backups of AdventureWorks.
USE master
GO
EXEC sp_addumpdevice 'disk', 'AdvWorksData', 
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\BACKUP\AdvWorksData.bak'

-- Back up the full AdventureWorks database.
BACKUP DATABASE AdventureWorks 
   TO AdvWorksData


sample3:
-- Create a logical backup device for data backups of AdventureWorks.
USE db2_locator
GO
EXEC sp_addumpdevice 'disk', 'db2_locator_backup', 'C:\tmp\db2_locator_backup.bak'

-- Back up the full AdventureWorks database.
BACKUP DATABASE db2_locator TO db2_locator_backup

sample4:
RESTORE DATABASE MyAdvWorks FROM MyAdvWorks_1