use master restore database AdventureWorks from disk = 'E:\databasebackup\AdventureWorks.bak' with replace, MOVE N'AdventureWorks_Data' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.5\MSSQL\Data\AdventureWorks.mdf', MOVE N'AdventureWorks_Log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.5\MSSQL\Data\AdventureWorks_log.ldf'
use master restore database ssc123 from disk = 'E:\1.bak' with replace, MOVE N'panydb' TO N'E:\MSSQL.1\MSSQL\Data\ssc123.mdf', MOVE N'ssc123_Log' TO N'E:\MSSQL.1\MSSQL\Data\ssc123_log.ldf'