Document Log Shipping Failover Process

-- 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