Use sde_sql
Go

Create Procedure RecoveryScript
as
    Alter Database SDE_SQL
    SET Single_User with
    Rollback IMMEDIATE

    use master
    go

    Restore Database SDE_SQL
    FROM DISK = 'C:UsersHFDesktopSQLSQLDatabaseBackup.bak'
    WITH REPLACE, STATS = 5