Red Gate forums :: View topic - Move Repository Directory
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

Move Repository Directory

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Random Lengths



Joined: 29 Sep 2008
Posts: 26
Location: Eugene, OR

PostPosted: Thu Jun 10, 2010 11:53 pm    Post subject: Move Repository Directory Reply with quote

I installed the Alert Repository to my production data directory. I now want it moved to another directory on the same server. How do I do this? Will I lose all my Alert history?
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Fri Jun 11, 2010 11:28 am    Post subject: Reply with quote

Hi,

Please read this KB article. You will not lose any data.

http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Response&c=knowledgebase/SQL_Response/KB200811000321.htm


Thanks,
Priya
Back to top
View user's profile Send private message
Random Lengths



Joined: 29 Sep 2008
Posts: 26
Location: Eugene, OR

PostPosted: Fri Jun 11, 2010 4:34 pm    Post subject: Kinda Reply with quote

OK, so that allowed me to move the repository, but it seems that not really what I wanted to do.
The Config.xml file pointed to a directory on the C drive, which was there and I moved it... But, the files I'm trying to move are not on the C drive, they are on the D drive. And look like this:

SQLResponse3cbdbea88e6b48b2ba6e641767152e7d.trc

My guess is that these are related to the actual alerts and or snapshots of the processes that caused the alerts. How do I manage where these files go?
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Fri Jun 11, 2010 10:51 pm    Post subject: Reply with quote

Hi,

The file which you have pointed are actually trace file created by SQL Response.

If you have turned trace ON on your SQL Sever instance then SQL Response creates these trace files. SQL Response creates these files and if any alert is raised then we copy parts of the trace in our alert snapshot file. These files have maximum size set (which is few KB) and they are deleted as soon as we have used it (generally within 5 minutes). Sorry but we do not have any way to manage these files. By default they go to SQL Server Data directory.

Thanks,
Priya
Back to top
View user's profile Send private message
Random Lengths



Joined: 29 Sep 2008
Posts: 26
Location: Eugene, OR

PostPosted: Fri Jun 11, 2010 10:58 pm    Post subject: Reply with quote

My data directory has 86 of these files. 13 from 2/2/2010, 22 from 2/9/2010, 3 from 3/21/2010, 23 from 5/18/2010, and the rest from within 20 minutes of now. Any of the files on any one day are within an hour of each other.


So, by your earlier statement then, can I just delete the files that are older than today? I guess I can live with 20 or so of these, but 86 is just too many.

I guess one option is to change the default data directory.
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Sat Jun 12, 2010 9:34 am    Post subject: Reply with quote

Ideally ... the clean up process should have deleted these files after SQL Response used it. But looks like somehow they have been left behind. Yes, please delete all these files which are older than today. After that if you see this happening again i.e. if older files are not getting deleted then please let us know.

Regards,
Priya
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