by ssi
17. November 2015 14:27
RESTORE DATABASE PROD FROM disk = 'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\MyBackup\UnZipped\dbase_FULL_20151215_230000.bak'
WITH REPLACE, FILE = 1, NORECOVERY, STATS=5, MOVE 'dbase_dat' TO 'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\dbase.mdf', MOVE 'dbase_Log' TO
'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\dbase_Log.ldf'
RESTORE LOG dbaseRecovering FROM DISK = 'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\MyBackup\UnZipped\dbase_backup_2015_06_05_040006_5970059.trn'
WITH NORECOVERY, FILE = 1;
RESTORE LOG dbaseRecovering FROM DISK = 'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\MyBackup\UnZipped\dbase_backup_2015_06_05_043000_6483931.trn'
WITH NORECOVERY, FILE = 1;
RESTORE LOG dbaseRecovering FROM DISK = 'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLMyBackup\UnZipped\dbase_backup_2015_06_05_050001_0024105.trn'
WITH NORECOVERY, FILE = 1;
--Put database back into operation
RESTORE DATABASE {0} WITH RECOVERY