Difference between Backup Dump and Backup Device ?

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

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

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