You can save a backup of your MS SQL databases to a single file on your hard drive. These backup files have names ending with the ".bak" file extension, and you use them to restore database backups ...
Database connectivity gives desktop and Web applications much of their value. .NET developers have products and framework objects that can tie a front-end application to SQL Server, MySQL, Sybase, ...