restoreDatabase.txt 477 Bytes

Edit Raw Blame History Permalink

EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [AIADatabaseV5]
FROM DISK = ''D:\Aamir\PRODSQLVM_RedGate_AIADatabaseV5_Full_20170408_22252.dmp'' WITH PASSWORD = ''N0tBl4nk'', RECOVERY,
MOVE ''AIADatabaseV5'' TO ''C:\Program Files (x86)\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Data\AIADatabaseV5_data.mdf'',
MOVE ''AIADatabaseV5_log'' TO ''C:\Program Files (x86)\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Data\AIADatabaseV5_log.LDF'',
REPLACE, ORPHAN_CHECK"'