Red Gate forums :: View topic - Is RedGate backup tool activated?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

Is RedGate backup tool activated?

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
garga1



Joined: 07 Mar 2012
Posts: 3

PostPosted: Wed Mar 07, 2012 6:51 pm    Post subject: Is RedGate backup tool activated? Reply with quote

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.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2305

PostPosted: Thu Mar 08, 2012 2:02 am    Post subject: Reply with quote

Try this:
Code:
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
Back to top
View user's profile Send private message Send e-mail
garga1



Joined: 07 Mar 2012
Posts: 3

PostPosted: Thu Mar 08, 2012 3:49 pm    Post subject: Reply with quote

Perfect solution. Thank you so much.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group