Is RedGate backup tool activated?

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Is RedGate backup tool activated?

Postby garga1 » Wed Mar 07, 2012 6:51 pm

Hi,
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:

SELECT NAME FROM MASTER..sysobjects WHERE NAME LIKE '%sqlbackup%'

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.
garga1
 
Posts: 3
Joined: Wed Mar 07, 2012 6:43 pm

Postby petey » Thu Mar 08, 2012 2:02 am

Try this:
Code: Select all
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 7
petey
 
Posts: 2234
Joined: Sun Apr 24, 2005 12:34 pm

Postby garga1 » Thu Mar 08, 2012 3:49 pm

Perfect solution. Thank you so much.
garga1
 
Posts: 3
Joined: Wed Mar 07, 2012 6:43 pm


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests