The backup of SQL Database set should be expired in 10 days, so enabled the Backup set will expire option and specified 10 days in the text boxīackup of SQL Database should be encrypted using AES128 algorithm, so enabled Backup encryptionĪnd chosen AES128 from the Algorithm drop-down box. I have changed the followingīackup of SQL Database should be compressed, so chosen Compress backup from the Under the options tab, you can set different options for the backup files. The backup should be copied to its corresponding directory, so click on Create a sub-directory for each database. The destination of the backup is \\192.168.0.103\Backups\Full Backup so specify the path Therefore, in the general tab, click on Databases drop-down box and select All databases and click on OK. The first maintenance plans generate a full backup of all the SQL databases and copy the backup to the networkĭrive. In the Maintenance plan configuration pan, drag and drop Back up Database Task from the toolbox and In the New Maintenance Plan dialog box, specify the name of the maintenance plan. Once connected to the instance, expand Management Right-click on the Maintenance Plans Select New To create a database maintenance plan, open SQL Server Management Studio (SSMS) and connect to the SQL Server The backup process should be created as followsĬreate a Maintenance Plan for Full Backup The backup set must be expired in 10 days Differential Backup: \\192.168.0.103\Backups\Differential Backup.The backup location must be the following: The backup must be encrypted, and once the backup completes, the backup’s integrity must be checked. Schedules areĭifferential Backup: Every day except Sunday at 2 AM The Full, Differential, and Log backup of all user and system SQL databases must be taken. This article is based on a use case, and the details are the following: In this article, I am going to show how we can automate the database backups using SQL Server database maintenance The maintenance plans can be used to perform maintenance on the local Tasks are called database maintenance plans. The SQL Server provides the predefined maintenance tasks that can be used to perform database maintenance. SQL Server Agent Jobs or Windows’ task scheduler.
These backups of SQL database can be automated by Instead of using theseĬostly tools, some organizations prefer to use SQL native backups. Tools use state of the art technology to protect the data, and some of them are very costly. There are various tools available that can be used to back up the data. Data is one of the most important assets of any organization, and as a database administrator, it is our In this article, we are going to learn how we can automate the backup of the SQL database using database maintenance
0 kommentar(er)
