Набор для создания копии базы

Набор для создания копии базы

BACKUP DATABASE [OldBase] TO  DISK = N'D:\SQL_Base\MSSQL11.TEST_SQL\MSSQL\Backup\OldBase_backup_ПередПереходомВПростуюМодель.bak' WITH NOFORMAT,
NOINIT,  NAME = N'OldBase-ПередПереходомВПростуюМодель', 
SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

USE [OldBase]
ALTER DATABASE [OldBase]
SET RECOVERY SIMPLE;
GO

BACKUP DATABASE [OldBase] TO  DISK = N'D:\SQL_Base\MSSQL11.TEST_SQL\MSSQL\Backup\OldBase_backup_ПростаяМодель.bak' WITH NOFORMAT,
NOINIT,  NAME = N'OldBase-ПростаяМодель', 
SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

CREATE DATABASE OldBase_Copy
ON 
	PRIMARY (NAME='OldBase', 
	FILENAME='D:\SQL_Base\MSSQL11.TEST_SQL\MSSQL\DATA\OldBase_Copy.mdf', 
	SIZE=200,
	FILEGROWTH=200 )
LOG ON (
	NAME='OldBase_log',
	FILENAME='D:\SQL_Base\MSSQL11.TEST_SQL\MSSQL\DATA\OldBase_Copy.ldf', 
	SIZE=1, 
	MAXSIZE=4096,
	FILEGROWTH=50
	) 
Go

USE [OldBase_Copy]
ALTER DATABASE [OldBase_Copy]
SET RECOVERY SIMPLE;
GO

USE [master]
RESTORE DATABASE [OldBase_Copy] 
FROM  DISK = N'D:\SQL_Base\MSSQL11.TEST_SQL\MSSQL\Backup\OldBase_ПростаяМодель.bak' WITH  FILE = 1,
MOVE N'OldBase' TO N'D:\SQL_Base\MSSQL11.TEST_SQL\MSSQL\DATA\OldBase_Copy.mdf',
MOVE N'OldBase_log' TO N'D:\SQL_Base\MSSQL11.TEST_SQL\MSSQL\DATA\OldBase_Copy.ldf',
NOUNLOAD,  REPLACE,  STATS = 5

GO