x

Query to retrieve RedGate backup license

Hi guys

We have about 40 different SQL servers in our enviroment, most of the servers have Redgate sql backup installed. I am new here and need to find out what license was used for what server, is it possible to get this info by quering the registry from SQL? using SQL 2008R2 and SQL 2012

Thanks

more ▼

asked May 12, 2014 at 12:14 PM in Default

avatar image

ruancra
1.2k 31 37 45

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

I would assume that it's stored somewhere, possibly in the registry. You might want to reach out to Red-Gate directly and see if they can tell you an easy way to do this.

In a quick search for documentation, I found this: http://documentation.red-gate.com/display/SBU7/The+Registered+SQL+Servers+pane which shows a dialog box that contains the information.

Hope this helps!

more ▼

answered May 12, 2014 at 12:50 PM

avatar image

JohnM
14.2k 3 7 14

Thanks John, I want to create a ssrs report detailing all the Database servers with their SQL backup serial key. Wanted to know if its possible to get it via SQL Server.

May 12, 2014 at 01:35 PM ruancra

You can read the registry from SQL Server, however I might suggest looking at Powershell. You could create a script that would populate a table in a database that would be able to feed your report.

Just a thought.

May 12, 2014 at 01:38 PM JohnM
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x13
x5

asked: May 12, 2014 at 12:14 PM

Seen: 717 times

Last Updated: May 12, 2014 at 01:38 PM

Copyright 2017 Redgate Software. Privacy Policy