Tag: Schedule Automatic Backup

Schedule Automatic Backup in SQL Server 2012 – Part2

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-Server 2012, Varinder Sandhu

In the previous post, we have scheduled automatic backup in SQL Server 2012 – Part1. As we have scheduled daily backup of database and backup file will be generated every day. It is a good practice that to delete backup files after a certain period of time as per requirement. Now we will add the Maintenance Clean Up Task along with the Back Up Database Task. Configure Clean Up Task From the Maintenance Plan Tasks tool box pane in the left

» Read more
, , , ,

Schedule Automatic Backup in SQL Server 2012 – Part1

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-Server 2012, Varinder Sandhu

You know it is very important to back up your SQL server database backup on the regular basis. So in this post, we will see how to schedule automatic backup in SQL server 2012. We will go step by step to schedule so that we all can understand each and every step clearly. Before scheduling automatic backup we have make sure the following two points: User should have the SYSADMIN privileges to schedule automatic backup. SQL Server Agent service should

» Read more
, , ,