USE [master] RESTORE DATABASE [YourDatabase.Name] FROM DISK = N'C:\PathToBackupFiles.bak' WITH RECOVERY