Home Forums SQL Server 2008 SQL Server 2008 Administration Restore Problem - connections to DB RE: Restore Problem - connections to DB
arnipetursson
SSCertifiable
Points: 6557
More actions
October 30, 2014 at 3:48 pm
#1755933
Just run something like this:
USE [master]
GO
ALTER DATABASE [foo] SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE
RESTORE DATABASE [foo] .....
ALTER DATABASE [foo] SET MULTI_USER WITH ROLLBACK IMMEDIATE