Синтаксис
USE master GO RESTORE DATABASE имя_базы FROM DISK = 'путь' WITH REPLACE
Script.sql
USE master GO RESTORE DATABASE zzz FROM DISK = 'D:\backup\zzz.bak' WITH REPLACE
USE master GO RESTORE DATABASE zzz FROM DISK = 'D:\backup\zzz.bak' WITH REPLACE