USE MASTER RESTORE DATABASE DB_DEMO FROM DISK = 'D:\DB_DEMO_backup.bak' WITH MOVE 'DB_DEMO' TO 'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DB_DEMO.mdf', MOVE 'DB_DEMO_LOG' TO 'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DB_DEMO_log.ldf', STATS = 10, REPLACE Go