Schedule daily SQL Database Backup
Hi guys, In practical cases we require backup and restore facility to our database which provides an essential safeguard for protecting critical data stored in SQL Server databases. To minimize the risk of catastrophic data loss, you need to back up your databases to preserve modifications to your data on a regular basis. Backup and restore strategy always protects databases against data loss caused by a variety of failures. Purpose and Scope: In this blog, I am going through step by step that will allow Users to schedule the backup to be taken on a particular interval Delete the backup copies after a certain period of time Prerequisites: SQL server 2000/2003/2008/2012 SQL server Agent (Up and running state) Steps: Schedule the database backup Steps: Make sure that SQL agent is in running state: Go To SQL Server Configuration Manager > SQL Server Services > Run SQL Server Agent (Set it to Run Automatically) If you are using new versions of SQL server then, Go To SQL ...