Try this.
1. Execute the T-SQL command
BACKUP DATABASE <DatabaseName> TO DISK = "D:\Database.bak"
Note: Here "D:\" is the drive on your database server. If your database and webserver are two different machines, then after executing the above T-SQL command, copy the file to your webserver.
2. Provide the hyperlink on your web page and set the href to the file.