Learn how to effortlessly perform a self-service SQL backup using Dell PowerProtect Data Manager. This step-by-step tutorial guides you through the process, ensuring your data remains secure and accessible.
Hello, everyone on this video. I will explain how to perform a SQL self-service backup using power protect data manager SQL agent software. First, open Microsoft SQL Management Studio as administrator once connected, locate an open S MS plug in, set it back up T and under general page configure different settings for the backup SQL server host. Select the SQL server where the backup will be performed for AG.
Make sure that windows cluster name is selected SQL server instance, select the SQL server to be protected for AJ G ensure that the windows cluster name is selected database filter are a filter to display all or some of the DVS only either for a AG or non A AG under their backup type. Define the backup level to be performed either full differential or transactional log. And their backup said, define the name for your backup piece, define the retention policy for your backup.
In this example, our backup will be expired after 30 days under power protected system, select the data domain appliance where the backup will be stored, select any existing data domain system or add a new one and configure lockbox settings and option page you can configure different options for the backup reliability. Define if a section of data must be performed before writing data to medium and how to behave. If there is any error transaction log defines whether to truncate the locks after a backup or not.
Stripes used to configure a striped backup. A number of stripes used simple recovery model defines how the backup should perform. Should N DB is comfortable with simple recovery model. Others other useful options like enabling the back for troubleshooting purposes, backup promotion and others. On top of the S MS plug in, we have a script generator tool that allows us to, to generate either a common line scripts, which a REDM SQL module commands line scripts that can be run over common line or T SQL scripts used to generate SQL service scripts. Once all the quiet options are configured, execute the backup A monitor and the monitor section.
Thank you for watching this video.
