Restore_AdventureWorks2017.sql

	USE [master];
	GO

	IF DB_ID('AdventureWorks2017') IS NOT NULL
	BEGIN
		ALTER DATABASE AdventureWorks2017 SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
		DROP DATABASE AdventureWorks2017;
	END;
	RESTORE DATABASE [AdventureWorks2017]
	FROM DISK = N'S:\MSSQL\BACKUP\AdventureWorks2017.bak'
	WITH MOVE N'AdventureWorks2017'
		 TO N'S:\MSSQL\Data\AdventureWorks2017.mdf',
		 MOVE N'AdventureWorks2017_log'
		 TO N'S:\MSSQL\Data\AdventureWorks2017_log.ldf',
		 REPLACE;
	GO

	IF DB_ID('AdventureWorks2017_COPY') IS NOT NULL
	BEGIN
		ALTER DATABASE AdventureWorks2017_COPY SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
		DROP DATABASE AdventureWorks2017_COPY;
	END;
	RESTORE DATABASE [AdventureWorks2017_COPY]
	FROM DISK = N'S:\MSSQL\BACKUP\AdventureWorks2017.bak'
	WITH MOVE N'AdventureWorks2017'
		 TO N'S:\MSSQL\Data\AdventureWorks2017_COPY.mdf',
		 MOVE N'AdventureWorks2017_log'
		 TO N'S:\MSSQL\Data\AdventureWorks2017_COPY_log.ldf',
		 REPLACE;
	GO