A lot of people came to me lately asking for an easy way to backup their MS SQL databases just like one would with MySQL or any other MySQL clone. In the case of Microsoft, you can easily script it in your ASP file and run that daily. Simply make a database connection and execute the following query:
BACKUP DATABASE EXAMPLEDB TO DISK = "FULL PATH NAME HERE"