Difference between Backup Dump and Backup Device ?

 Posted by PandianS on 12/8/2010 | Category: Sql Server Interview questions | Views: 4178 | Points: 40
Answer:

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 | Alert Moderator 

Comments or Responses

Login to post response