• Just run something like this:

    USE [master]

    GO

    ALTER DATABASE [foo] SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE

    GO

    RESTORE DATABASE [foo] .....

    GO

    USE [master]

    GO

    ALTER DATABASE [foo] SET MULTI_USER WITH ROLLBACK IMMEDIATE

    GO