Files
DP44/Common/DTS.Common.Storage/Restore_As_DataPROPre20_RemoteDB.sql
2026-04-17 14:55:32 -04:00

10 lines
240 B
Transact-SQL

USE master
GO
RESTORE DATABASE $(DBNAME)Pre20 FROM DISK='C:\DataPRO_SQL\$(DBNAME)Backup.bak' WITH
MOVE 'DataPRO' TO 'C:\DataPRO_SQL\$(DBNAME)Pre20.mdf',
MOVE 'DataPRO_log' TO 'C:\DataPRO_SQL\$(DBNAME)Pre20_log.ldf'
GO