Old backup files are usually obsolete, and they can be easily identified and deleted from the drive either manually, or by using a script.ĭepending on the user requirements, backup names can contain information such as server name, SQL Server instance name, database name, backup type, date and time. Properly formatted backup names make the job of organizing and maintaining the backup sets much easier. In both cases, it is necessary to format database backup names properly. Some database administrators use the batch or power shell scripts for automation, while others prefer to use various 3 rd party solutions. In order to successfully implement these strategies in a larger environment, configuring automated backup and restore processes is a must. Well organized backup and restore strategies will definitely help with this. When working with a large number of databases on multiple SQL Servers, creating a foolproof disaster recovery plan can be challenging.
0 kommentar(er)
