Скрипт типовой задачи – скопировать боевую базу в тестовую

--- сreate copy database ZKGU to ZKGUDEMO
-- create backup database ZKGU
USE zkgu;
GO
BACKUP DATABASE zkgu
TO DISK = 'D:\bak\zkgu.bak'
   WITH FORMAT,
      MEDIANAME = 'Z_SQLServerBackups',
      NAME = 'Full Backup of ZKGU';
GO
-- restore database ZKGU to database ZKGUDEMO
USE master;
GO
-- First determine the number and names of the files in the backup.
-- ZKGU_Backup is the name of the backup device.
RESTORE FILELISTONLY
   FROM ZKGU_Backup;
-- Restore the files for ZKGUDEMO.
RESTORE DATABASE zkgudemo
   FROM ZKGU_Backup
   WITH RECOVERY,
   MOVE 'ZKGU_Data' TO 'D:\MSSQL_Data\zkgudemo_Data.mdf',  
   MOVE 'ZKGU_Log' TO 'F:\MSSQL_Logs\zkgudemo_Log.ldf';
GO
-- End of program