Comments
Sort by recent activity
Hello Anu,
Replied to your email. Sorry for the late reply - I was out of office whole last week on training.
Thanks / comments
Hello Anu,
Replied to your email. Sorry for the late reply - I was out of office whole last week on training.
Thanks
@ RBA
Sorry. Did not check back on the thread until today. Marianne
Thanks, installed and it seems to fix the issue for me. No more green spinning thing on server or restore button / comments
@ RBA
Sorry. Did not check back on the thread until today.Marianne
Thanks, installed and it seems to fix the issue for me. No more green spinning thing on server or restore button
If the green spinner completes, is it faster from then on or always slow on refresh?
No idea on speed as it is still spinning with "Retrieving backup history ...". I am beginning to think it's not going to show any history information. / comments
If the green spinner completes, is it faster from then on or always slow on refresh?
No idea on speed as it is still spinning with "Retrieving backup history ...". I am beginning to think it's...
I do not meant to hijack smccreadie's thread. Sorry ... but thought I do a quick update.
The spinning green thing did not stop - waited till the end of yesterday and close out the app.
This morning launched SQL Backup again, and server starts spinning, so did Activity History. Waited for about an hour - it did not stop, so I close out the app.
Did not bother to try Restore or Backup. Doing it the old fashion tsql way. Unfortunately, until the fix for this issue, SQL Backup tool is pretty much useless to me now. / comments
I do not meant to hijack smccreadie's thread. Sorry ... but thought I do a quick update.
The spinning green thing did not stop - waited till the end of yesterday and close out the app.
This morning...
I am trying to restore and experiencing the same issue. I have 3 instances defined and the spinning thing has been going for more than 30 minutes and still running once I click the Restore button.
I checked http://www.red-gate.com/supportcenter/c ... heLocation
as suggested and %LOCALAPPDATA%\Red Gate\SQL Backup\Server Data\localDataCache.dat is only 38KB and 1.dat-journal is only 11KB. These are the only 2 files that has today's date modified.
As for "Reducing the amount of data in the activity cache", we have a SQL job that deletes the server backup history that is older than 30 days.
I'm just glad I'm not trying to urgently restore this db. I'm glad it's a test restore to make sure the backup is good.
Just wondering if the spinning thing will ever stop and the activity history will actually come up? And if so, how long did it took? / comments
I am trying to restore and experiencing the same issue. I have 3 instances defined and the spinning thing has been going for more than 30 minutes and still running once I click the Restore button.
...
Sorry for the late reply.
Yes it did. / comments
Sorry for the late reply.
Yes it did.
ChrisAVWood wrote:
NORECOVERY means it is not available for use. You need to use RECOVERY.
Chris
I'm going to try restore with recovery. / comments
ChrisAVWood wrote:
NORECOVERY means it is not available for use. You need to use RECOVERY.
Chris
I'm going to try restore with recovery.
Yes I did. The ABC_ARCHIVE database data file is 771GB and log file is 18 GB - which is the same size as the ABCPROD database on the day the backup was taken.
To rule out the hard disk space (at first I thought it was the hard disk space issue failure); I still have 2.8 Terabytes on that drive where the data & log files are located. / comments
Yes I did. The ABC_ARCHIVE database data file is 771GB and log file is 18 GB - which is the same size as the ABCPROD database on the day the backup was taken.
To rule out the hard disk space (at fi...
Used GUI - but, this is in the Activity Log - db name changed for forum posts.
SQL Backup log file 7.0.5.1
-SQL "RESTORE DATABASE [ABC_ARCHIVE]
FROM DISK = '\\servername\foldername\foldername\ABCPROD_FULL_20130109.bak'
WITH NORECOVERY, DISCONNECT_EXISTING,
MOVE 'ABCPROD_Data.MDF' TO 'F:\Datafiles\ABC_ARCHIVE_Data.MDF',
MOVE 'ABCPROD_Log.LDF' TO 'F:\Logfiles\ABC_ARCHIVE_Log.LDF',
REPLACE " / comments
Used GUI - but, this is in the Activity Log - db name changed for forum posts.
SQL Backup log file 7.0.5.1
-SQL "RESTORE DATABASE [ABC_ARCHIVE]
FROM DISK = '\\servername\foldername\foldername\ABCPR...
If you meant this thread http://www.red-gate.com/messageboard/vi ... norecovery
the thread OP got an error. I do not have an error. In fact, the Activity Log reports restore process completed successfully. However, on both SQL Backup and SSMS, that particular database has the status "restoring ...". And it has been there for 2 days; but the SQL Backup suggests the restore completed successfully in about 1 hour and 27 mins. / comments
If you meant this threadhttp://www.red-gate.com/messageboard/vi ... norecovery
the thread OP got an error. I do not have an error. In fact, the Activity Log reports restore process completed succes...