Database With Fun (While 1 = 1)

 Lets tackle the SQL Server database backups today: I had a camera phone back when I was in college. I used to take pictures of everything. I had around 2000+ pictures on it. One day I dropped the phone in water. It never turned back on. I lost all the photos.  I learned a valuable lesson that day: Always take backups. Backup everything. When SQL Server is configured with any Application, all the app data is stored in the databases. You don't want to end up feeling miserable when your server crash and all the data is lost. Database backups help you avoid just that. Lets take a look at the basics: Before you can understand backups, you need to know what gets stored in the databases and logs. Database files = MDF file, LDF file & 0 or more NDF file. NDF file is logically same as MDF file. The most important question: how much data you can afford to lose? To understand this better, lets take a look at one example. There's a person at your company's gate who notes in a note...