Red Gate forums :: View topic - Collect historical data for offline viewing
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

Collect historical data for offline viewing

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dbarbon



Joined: 14 Dec 2011
Posts: 2

PostPosted: Wed Dec 14, 2011 9:43 am    Post subject: Collect historical data for offline viewing Reply with quote

Hi all members, this is my first post.
I bought SQL Monitor 2.3 and I installed it on a customer's production server.
I want to backup the RedGateMonitor db on regular basis (prior of data purging) , transfer it to my server and analyze historical data offline.

Is it possible ? How to achieve this target?
Thanks.
Back to top
View user's profile Send private message
RBA



Joined: 05 Jun 2009
Posts: 148
Location: Cambridge

PostPosted: Wed Dec 14, 2011 2:44 pm    Post subject: Reply with quote

Hi,

The SQL Monitor repository is no different to any other SQL Server database. As such, any method for database replication will probably do (mirroring, replication, log shipping).

Our SQL Backup product allows you to set up log shipping with ease, so if they have a licence you have a quick win.

The data purging will mean that replicated or mirror DBs lose data over time. If this is unacceptable, then I'd just recommend taking full backups and restoring them when you want to analyse the time period that backup relates to.

As for the actual analysis, you can install SQL Monitor locally and point it at the restored database. To prevent it from modifying your copy, it is essential that you configure your local copy of SQL Monitor to be in 'slave mode' (=read only). Details of this I can email you, if that's what you want to do: robin.anderson@red-gate.com.

Regards,
_________________
Robin Anderson
Development
Red-Gate Software
Back to top
View user's profile Send private message Send e-mail
dbarbon



Joined: 14 Dec 2011
Posts: 2

PostPosted: Thu Dec 15, 2011 4:32 pm    Post subject: Reply with quote

Hi Robin, thanks for your response.

Quote:
As for the actual analysis, you can install SQL Monitor locally and point it at the restored database. To prevent it from modifying your copy, it is essential that you configure your local copy of SQL Monitor to be in 'slave mode' (=read only). Details of this I can email you, if that's what you want to do: robin.anderson@red-gate.com.


Yes, this is exactly what I want; can you send a mail with details at dbarbon@olicom.eu ?

Thanks again.
Back to top
View user's profile Send private message
RBA



Joined: 05 Jun 2009
Posts: 148
Location: Cambridge

PostPosted: Thu Dec 15, 2011 5:06 pm    Post subject: Reply with quote

Emailed.

Regards,
_________________
Robin Anderson
Development
Red-Gate Software
Back to top
View user's profile Send private message Send e-mail
Richard Line



Joined: 01 Feb 2012
Posts: 2
Location: Staffordshire, UK

PostPosted: Wed Feb 01, 2012 11:16 pm    Post subject: Reply with quote

Hi

Just purchased some Production and Development licenses of SQL Monitor and would like to be able to provide Read Only access to developers. Under these licenses would I be able to into the web element twice once to DBA use and once in 'slave mode' for read only access for developers? If so how would I acheive this?

Thanks
Back to top
View user's profile Send private message
RBA



Joined: 05 Jun 2009
Posts: 148
Location: Cambridge

PostPosted: Thu Feb 02, 2012 10:38 am    Post subject: Reply with quote

Hi,

Please get in touch via email and I'll provide details: robin.anderson@red-gate.com.

Note that slave mode was designed for our public facing demo, rather than for customer use, and will display marketing messages.

We will be releasing version 3.0 at some point over the next few months and one of the features will the addition of user roles, including a read-only role.

You won't have to use up a licence if you want a second SQL Monitor web server running in slave mode.

Regards,
_________________
Robin Anderson
Development
Red-Gate Software
Back to top
View user's profile Send private message Send e-mail
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