SQL Server BDC Hints and Tips: VDI Seeding for High Availability


 

Moved from: bobsql.com

 

A high availability SQL Server BDC uses the Virtual Device Interface (VDI) to seed databases to secondary replicas. (https://docs.microsoft.com/en-us/sql/big-data-cluster/

 

 

deployment-high-availability?view=sql-server-ver15)

 

VDI History – https://docs.microsoft.com/en-us/archive/blogs/psssql/how-it-works-sql-server-vdi-vss-backup-resources

VDI was introduced to SQL Server allowing custom providers to backup/restore data to/from SQL Server like a file interface would.   The VDI interface is a client/server event driven model used for commands such as Read, Write, Flush, …  When the SQL Server backup would have called the Win32 WriteFile API backup instead calls the server instance, WriteCmd and the client instance accepts and processes the write event.