Move Repository Directory

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

Move Repository Directory

Postby Random Lengths » Thu Jun 10, 2010 11:53 pm

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?
Random Lengths
 
Posts: 27
Joined: Mon Sep 29, 2008 11:02 pm
Location: Eugene, OR

Postby priyasinha » Fri Jun 11, 2010 11:28 am

Hi,

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

http://www.red-gate.com/supportcenter/C ... 000321.htm


Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Kinda

Postby Random Lengths » Fri Jun 11, 2010 4:34 pm

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?
Random Lengths
 
Posts: 27
Joined: Mon Sep 29, 2008 11:02 pm
Location: Eugene, OR

Postby priyasinha » Fri Jun 11, 2010 10:51 pm

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
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby Random Lengths » Fri Jun 11, 2010 10:58 pm

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.
Random Lengths
 
Posts: 27
Joined: Mon Sep 29, 2008 11:02 pm
Location: Eugene, OR

Postby priyasinha » Sat Jun 12, 2010 9:34 am

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
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests