-- PACK++
USE [master]
GO
ALTER DATABASE [Pack_BackUp] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [Pack_BackUp] SET COMPATIBILITY_LEVEL = 140
GO
USE [Pack_BackUp]
GO
DBCC SHRINKFILE (N'Clear_Bace_log' , 0, TRUNCATEONLY)
GO
USE [master]
--BACKUP LOG [Pack_BackUp] TO  DISK = N'D:\SQL\backup\Pack_BackUp_LogBackup_2018-06-07_12-27-30.bak' WITH NOFORMAT, NOINIT,  NAME = N'Pack_BackUp_LogBackup_2018-06-07_12-27-30', NOSKIP, NOREWIND, NOUNLOAD,  NORECOVERY ,  STATS = 5
--ALTER DATABASE [Pack_prov] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
RESTORE DATABASE [Pack_BackUp] FROM  DISK = N'D:\SharedSQL\Pack_DB_Work_backup.bak' WITH  FILE = 1,  MOVE N'Clear_Bace' TO N'C:\SQL\Pack_BackUp.mdf',  MOVE N'Clear_Bace_log' TO N'C:\SQL\Pack_BackUp_log.ldf',  NOUNLOAD,  REPLACE,  STATS = 5
--ALTER DATABASE [Pack_prov] SET MULTI_USER
GO
USE [master]
GO
ALTER DATABASE [Pack_BackUp] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [Pack_BackUp] SET COMPATIBILITY_LEVEL = 140
GO
-- PACK--

-- AVTO++
USE [master]
GO
ALTER DATABASE [Auto_Develop] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [Auto_Develop] SET COMPATIBILITY_LEVEL = 140
GO
USE [Auto_Develop]
GO
DBCC SHRINKFILE (N'tire_db_work_log' , 0, TRUNCATEONLY)
GO
USE [master]
--BACKUP LOG [Auto_Develop] TO  DISK = N'D:\SQL\backup\Pack_BackUp_LogBackup_2018-06-07_12-27-30.bak' WITH NOFORMAT, NOINIT,  NAME = N'Pack_BackUp_LogBackup_2018-06-07_12-27-30', NOSKIP, NOREWIND, NOUNLOAD,  NORECOVERY ,  STATS = 5
--ALTER DATABASE [Pack_prov] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
RESTORE DATABASE [Auto_Develop] FROM  DISK = N'D:\SharedSQL\tire_db_work_backup.bak' WITH  FILE = 1,  MOVE N'tire_db_work' TO N'C:\SQL\Auto_Develop.mdf',  MOVE N'tire_db_work_log' TO N'C:\SQL\Auto_Develop_log.ldf',  NOUNLOAD,  REPLACE,  STATS = 5
--ALTER DATABASE [Pack_prov] SET MULTI_USER
GO
USE [master]
GO
ALTER DATABASE [Auto_Develop] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [Auto_Develop] SET COMPATIBILITY_LEVEL = 140
GO

-- AVTO--

-- [Pack_Develop]++
USE [master]
GO
ALTER DATABASE [Pack_Develop] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [Pack_Develop] SET COMPATIBILITY_LEVEL = 140
GO
USE [Pack_Develop]
GO
DBCC SHRINKFILE (N'Clear_Bace_log' , 0, TRUNCATEONLY)
GO
USE [master]
--BACKUP LOG [Auto_Develop] TO  DISK = N'D:\SQL\backup\Pack_BackUp_LogBackup_2018-06-07_12-27-30.bak' WITH NOFORMAT, NOINIT,  NAME = N'Pack_BackUp_LogBackup_2018-06-07_12-27-30', NOSKIP, NOREWIND, NOUNLOAD,  NORECOVERY ,  STATS = 5
--ALTER DATABASE [Pack_prov] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
RESTORE DATABASE [Pack_Develop] FROM  DISK = N'D:\SharedSQL\tire_db_work_backup.bak' WITH  FILE = 1,  MOVE N'tire_db_work' TO N'C:\SQL\Pack_Develop.mdf',  MOVE N'tire_db_work_log' TO N'C:\SQL\Pack_Develop_log.ldf',  NOUNLOAD,  REPLACE,  STATS = 5
--ALTER DATABASE [Pack_prov] SET MULTI_USER
GO
USE [master]
GO
ALTER DATABASE [Pack_Develop] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [Pack_Develop] SET COMPATIBILITY_LEVEL = 140
GO

-- [Pack_Develop]--


-- AVTONAC++
USE [master]
GO
ALTER DATABASE [auto_nac] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [auto_nac] SET COMPATIBILITY_LEVEL = 140
GO
USE [auto_nac]
GO
DBCC SHRINKFILE (N'tire_ns_log' , 0, TRUNCATEONLY)
GO
USE [master]
--BACKUP LOG [auto_nac] TO  DISK = N'D:\SQL\backup\Pack_BackUp_LogBackup_2018-06-07_12-27-30.bak' WITH NOFORMAT, NOINIT,  NAME = N'Pack_BackUp_LogBackup_2018-06-07_12-27-30', NOSKIP, NOREWIND, NOUNLOAD,  NORECOVERY ,  STATS = 5
--ALTER DATABASE [auto_nac] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
RESTORE DATABASE [auto_nac] FROM  DISK = N'\\agp-vpe\SharedSQL\tire_ns_backup.bak' WITH  FILE = 1,  MOVE N'tire_ns' TO N'D:\SQL\auto_nac.mdf',  MOVE N'tire_ns_log' TO N'D:\SQL\auto_nac_log.ldf',  NOUNLOAD,  REPLACE,  STATS = 5
--ALTER DATABASE [auto_nac] SET MULTI_USER
GO
USE [master]
GO
ALTER DATABASE [auto_nac] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [auto_nac] SET COMPATIBILITY_LEVEL = 140
GO

-- AVTONAC--