1. The term Backup Dump
and Backup Device
are the same and does the same activity.
2. Then, why we are using the system stored procedure sp_addumpdevice to define a Backup device.
3. The reason is SQL Server 6.5 and earlier, the concept of Backup Device actually used the syntax as given below
DUMP DATABASE ....
DUMP LOG ....
4. So we still using the procedure(sp_addumpdevice) to define Backup Device for backward compatibility
Asked In: Many Interviews |