Systems, consultation and development 

Facebook E-mail

Point-in-time SQL Server recovery

Assuming the backups are from a Full backup set with a set of transaction logs RESTORE DATABASE NewDatabase FROM DISK = ‘F: \BackupFiles\OldFullBackup.bak’ WITH MOVE ‘OldfullDB’ TO ‘C:\DataFiles\TmpDatabase.mdf’, MOVE ‘OldfullDB_log’ TO ‘C:\DataFiles\TmpDatabase_Log.ldf’, NORECOVERY Remember, NORECOVERY means, noone can connect yet (A VERY GOOD THING)! Now, onto the transaction logs For each one, in chronological order…

Home Posts tagged "logs"