/*
Easy SQL restores for all LFS applications
Joe Scott, Lake Financial Systems
joe.scott@lake.co.uk
*/

DECLARE @bakpath NVARCHAR(250) = ''
DECLARE @bakprefix NVARCHAR(50) = ''

USE [master]
ALTER DATABASE [SunSystemsData] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
RESTORE DATABASE [SunSystemsData] FROM  DISK = N'G:\Media\Live to UAT\Q2 2023\SunSystemsData.bak' WITH FILE = 1, REPLACE,  STATS = 5
ALTER DATABASE [SunSystemsData] SET MULTI_USER

GO

ALTER DATABASE [SunSystemsDomain] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
RESTORE DATABASE [SunSystemsDomain] FROM  DISK = N'G:\Media\Live to UAT\Q2 2023\SunSystemsDomain.bak' WITH FILE = 1, REPLACE,  STATS = 5
ALTER DATABASE [SunSystemsDomain] SET MULTI_USER

GO

ALTER DATABASE [SunSystemsSecurity] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
RESTORE DATABASE [SunSystemsSecurity] FROM  DISK = N'G:\Media\Live to UAT\Q2 2023\SunSystemsSecurity.bak' WITH FILE = 1, REPLACE,  STATS = 5
ALTER DATABASE [SunSystemsSecurity] SET MULTI_USER

GO