help SQL Clusters

[SoftwareNinja]

Hi all,

 

Currently we use the fingerprint (database_guid) to validate the sql server a client is connected too.

I am wondering is there a way set the group id for a few servers so when it's switched, we can check the group_database_id?

 

I ran this comment in SQL to view the database ID's.

SELECT d.name, drs.database_guid, d.group_database_id
FROM sys.databases d
JOIN sys.database_recovery_status drs
ON d.database_id = drs.database_id

I hope I made sense above and hopefully someone might be able to shine some light on this.

 

Thanks in advance.

Scott

[Franck]

Well a cluster is a group so if you want a "groupID" like you call it, it will all be the same. Unless you have many cluster than in that case you know which you want to connect to, it doesn't do it by magic.

 

Right now as you describe it's either missing information or it's the X/Y Problem.

[SoftwareNinja]

1 hour ago, Franck said:

Well a cluster is a group so if you want a "groupID" like you call it, it will all be the same. Unless you have many cluster than in that case you know which you want to connect to, it doesn't do it by magic.

 

Right now as you describe it's either missing information or it's the X/Y Problem.

Okay so the fingerprint(uid) should be the same when the server is switched? 

[Franck]

23 minutes ago, ScottDurkin said:

Okay so the fingerprint(uid) should be the same when the server is switched? 

Is it a load balancing cluster / disaster recovery ? aka many clone database ?