I have two full backups of different dates first full backup is of date lets suppose 21-05-2017 and I have restored that backup to client machine (RESTORE WITH NO RECOVERY) and now I got second full back on date : 26-05-2017 , now I want to restore that full backup on previous restored Full back on my client machine. Any one tell me what are advantages and disadvantages of restoring full backup over full backup .right now I am deleting previous restored database and again restore latest full database but it consume time . Any one tell me what are advantages and disadvantages of restoring full backup over full backup. … ?
Advertisement
Answer
Simple answer, No advantage of restoring an older full backup and then restoring another newer backup on top of that. Your restore of the newer full backup will overwrite the restore of the older backup.
Disadvantages: Simply waste of time and recourses.