-- Document Log Shipping Failover Process
-- Taking Warm Stand By Server to Active Primary Server
-- Use Master Database
RESTORE DATABASE Testing
WITH RECOVERY
GO
-- Take Database to Single User Mode
USE [master]
GO
ALTER DATABASE [Testing] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
-- Take Database to Multi User Mode
USE [master]
GO
ALTER DATABASE [Testing] SET MULTI_USER WITH ROLLBACK IMMEDIATE
GO
