Red Gate forums :: View topic - red gate activity history constant refresh state
Return to www.red-gate.com RSS Feed Available

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

red gate activity history constant refresh state

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
hespinoza



Joined: 29 Jan 2013
Posts: 4

PostPosted: Mon Aug 12, 2013 10:27 pm    Post subject: red gate activity history constant refresh state Reply with quote

I'd like to review the activity history for one of my servers but no matter how long I leave the window it will never display the activity history for one my of sql servers. I have already checked the log activity directory and cleaned it out. Any suggestions?
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Tue Aug 13, 2013 11:26 pm    Post subject: Reply with quote

What version of the tool are you on?
Can you try updating to the latest version of the tool?
If you continue to experience the issue.
The first thing to try is to clear the Activity Cache or *.dat files as follows:

1. Close the GUI connections.
2. Navigate to this directory on the machine where the SQL backup GUI is installed:
C:\Users\<username>\AppData\Local\Red gate\SQL Backup\ServerData
3. In this folder you will find one or more .dat files, for example 1.dat, 31.dat, localDataCache.dat.
4. Delete all the *.dat files in the ServerData folder.
5. Now re-open the GUI. The *.dat files deleted in the previous step will be recreated. This may take awhile while the files are rebuilt. Are you now able to view the Activity History?

For a majority of customers the above resolves the issue.

However there are tiny few whose Local Data Store corrupts for some reason, so need to follow the steps below. These include repeating the above plus more.

1. Close the SQL Backup GUI
2. Navigate to this directory on the machine where the SQL backup GUI is installed:
C:\Users\<username>\AppData\Local\Red gate\SQL Backup\ServerData
3. In this folder you will find one or more .dat files, for example 1.dat, 31.dat, localDataCache.dat.
4. Delete all the *.dat files in the ServerData folder.
5. On the machine where the SQL Instance is located stop the SQL Backup Agent service.
6. Locate the SQL BackupLocal Data Store. The default path is as follows:
C:\ProgramData\Red Gate\SQL Backup\Data\<SQL Instance name>
7. Rename the existing data.sdf file to OLDdata.sdf.
8. Restart the SQL Backup Agent Service, this step will create a new data.sdf.
9. Now re-open the GUI. The *.dat files deleted in step 4 will be recreated. Are you now able to view the Activity History? Depending how much activity history there is you may need to wait for a while.

Some users have also reported that reducing the amount of data in the activity cache can improve the time it takes to populate the history.
https://documentation.red-gate.com/display/SBU73/Activity+cache+location
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
maddave



Joined: 11 Apr 2013
Posts: 18

PostPosted: Tue Aug 27, 2013 9:32 am    Post subject: Reply with quote

I found the only way to get the backup history to display quickly, was to reduce the amount of history data held down to 5 days worth. Even then it takes about 30 seconds to refresh.
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