The best SQL Server backup scripts, ever!
On the <very big data warehouse project>, we use Ola Hallengrens scripts for backup and database consistency checks.
They kick ass. They are free to use. And they are easy to understand and set up. My warmest recommendations.
As Brent Ozar writes: "Ola Hallengren publishes a free set of database maintenance scripts that are like maintenance plans that went to college, married into a nice family, and went to training school afterwards."
Read more at