Simplifying MS-SQL Backup Administration with Credential Rules
In many organizations, new MS-SQL Servers are added frequently—often several times a month—and each addition typically triggers a support ticket to enable backups. Most customers have already automated the deployment of the NetBackup client as part of their standard server provisioning process. Previous versions of NetBackup offered Instance Groups to help manage this process. However, with the release of NetBackup 11, we’ve introduced two powerful new features that replace and significantly enhance that functionality: Credential Rules and Intelligent Queries. To back up MS-SQL instances, NetBackup must authenticate using valid credentials. Some organizations manage this with a single, centrally managed credential (often integrated with CyberArk), while others use different credentials based on environment (e.g., production vs. test) or location. Credential Rules automate the credential assignment process. They allow NetBackup or MS-SQL administrators to define policies that are automatically applied to newly discovered MS-SQL instances. Important Note: Credential Rules apply only to newly discovered systems—they do not retroactively assign credentials to previously credentialed systems. Example Scenario Let’s look at a simple example of how Credential Rules can streamline your workflow: Host.test.company.com – Test/Dev environment Host.prod.company.com – Production environment If your organization uses different credentials for production and test/dev environments, you can configure Credential Rules to apply the correct credentials automatically: Rule: Production Hostname ends with prod.company.com Apply: MS-SQL Production Credential Rule: Test Hostname ends with test.company.com Apply: MS-SQL Test Credential It’s that simple. Just configure your rules once, and NetBackup will handle new server additions automatically—ensuring new MS-SQL instances are protected from day one. Credential Rules are yet another way NetBackup helps you streamline data protection and reduce manual administrative overhead. More information is available in the NetBackup 11 documentation or just view the short video demo attached to this article.
Use The Java Administration Console (GUI) To Learn What Linux/Unix Commands Are Being Run Under The Covers
When I began learning AIX, I relied heavily on the AIX system administration tool called SMIT (GUI) or SMITTY (menu based). One of the great things about SMIT is when you "point and clicked" to create a user account, configure NFS, etc., SMIT displays the actual Unix commands being executed on the bottom of the SMIT window. This is how I learned the basics of the Unix command line.
