Is RedGate backup tool activated?

garga1garga1 Posts: 9
edited March 8, 2012 9:49AM in SQL Backup Previous Versions
We use RedGate backup tool in our environment to backup giant databases. Our entire team has permissions to install the tool on the servers they are responsible for. When the license limit is reached, the activation fails. So far so good. But it becomes a nightmare for me to find out where it is installed and more important, licensed. I can run this query in SSMS on a SQL Server group of servers to find out if the tool is installed:


and it gives me, say, 20 servers. But how to know if all those 20 are licensed or trial versions?

I don't want to RDP into every server to find this out. Thru command line, registry read or sql query would be the desired solution.

Please help.


  • peteypetey Posts: 2,358 New member
    Try this:
    DECLARE @licensetype INT
    DECLARE @version varchar(16)
    DECLARE @serialnumber varchar(64)
    EXEC master..sqbutility 1021, @licensetype OUT, @version OUT, @serialnumber OUT
    SELECT 	@@servername server,
    	CASE @licensetype WHEN 0 THEN 'Expired trial' 
    			  WHEN 1 THEN 'Trial' 
    			  WHEN 2 THEN 'Standard' 
    			  WHEN 3 THEN 'Professional' 
    			  WHEN 4 THEN 'Beta' 
    			  WHEN 6 THEN 'Lite' 
    			  WHEN 8 THEN 'Read-only' 
    	END AS license,
    	@version version, @serialnumber serialnumber
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Perfect solution. Thank you so much.
Sign In or Register to comment.