How to Take Database Backup in SQL Server 2008 R2 Step by Step Creating regular…