Prerequisites and Must know Configure or integrate Online Database backup for Microsoft SQL Server

Microsoft SQL Server integration

 Below details are captured as per Data Protector backup tool:

Available Backup Types:

• Full database backup
• Transaction log backup
• Differential database backup

Considerations:

• Using Parallelism you can back up more than one SQL Server database at a time or back up a single database using multiple streams
• Ex: Database parallelism = 4, Overall Concurrency = 10
• DB1, DB2, DB3, DB4 = 4 parallelism
• DB1 with 2 Media agents, DB2 with 2 media agents, DB3 with 2 media agents and DB4 with 2 media agents
• Altogether its running with 10 streams (when you add 4 parallelism)
• DP executable sql_bar.exe uses SQL Server Virtual Device Interface (VDI) commands from SQL Server
• Backup API or VDI: the backup interface introduced with SQL Server.
• You can back up the whole server, standalone user databases, user databases belonging to availability groups, or certain databases (Master, Model, Distribution, Msdb)

Prerequisites:

• User must have fixed server role “sysadmin” to backing up and restoring SQL Server data
• Required components for a SA User: Login='user'; Password='encoded_password'; Domain='domain'; Port='PortNumber (Default is 1433)';

• When you use Integrated authentication: Inet service should run under a Windows domain user account which has appropriate SQL Server permissions (or use user impersonation instead)
• In a Cluser environments: Agents must be installed in cluster aware clients and user must have cluster administrator rights.

Share this

ChinniLax