Can you backup 2 identical SQL instances to one NBU environment?
I'm currently having an issue with a customer that has setup a Development and Production environments where the MSSQL cluster servers are identical in everything but IP. Even then, the IPs are the same but accessible through a series of natted IPs that differ, located on the upstream firewalls. Overkill, I know.
I'm currently having an issue attempting to install SQL agents on both the dev SQL cluster and the production SQL cluster. The dev environment has been up and running and backing up for some time now and today when I went to go ahead and setup the prod environment, ran into an issue where the SQL instance names are identical.
Does anyone know of a way to backup two SQL instances (using the SQL agent) to the same NBU environment when they utilize the same name? Assigning a different client name and testing hostname resolution and altnames listings work for the configuration checks, but when the MSSQL job is kicked off and the parent job creates a child job with the db name to be backed up, it is populating the SQL instance name, which is already setup and pointing to the dev server, and backs up the dev db data.
NBU environment: Windows 2003 Std SP2
SQL environment: Windows 2003 R2 x64, SQL Server 2005