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…

Restore a Bare Metal backup to a Hyper-V VM

Recently I had the need to recover an old backup where the original hardware was long since gone. Using Hyper-V I booted off the recovery disk and pointed at the bare metal set and went off for a very long walk as the restore did it’s thing. After rebooting into the restored disk I was…

Home Posts tagged "recovery"