How can we help you today? How can we help you today?
jcricegp
Activity overview Badges (0) Posts (8) Comments (10)

Comments

Sort by recent activity
Chris, Thanks for the reply, but we do not use DLM Automation so this will not work for me. John R. / comments
  1. Community
  2. SQL Compare
  3. License Activation for SQL Compare 13 without Internet Access
Chris, Thanks for the reply, but we do not use DLM Automation so this will not work for me. John R.
0 votes
Chris, If you are asking if I ran the "SQLCompare.exe \activateSerial:" from the RedGate SQLComplare directory, Yes that is the command I used. The command did not open a window. I also attempted to activate my Oracle Schema Compare using the appropriate executeable. An activate window did open, but it requested that I login using my RedGate Account. John R. / comments
  1. Community
  2. SQL Compare
  3. License Activation for SQL Compare 13 without Internet Access
Chris, If you are asking if I ran the "SQLCompare.exe \activateSerial:" from the RedGate SQLComplare directory, Yes that is the command I used. The command did not open a window. I also attempted t...
0 votes
Alex, Thanks, I guess this answers my questions. This is the Activation Web Page that I have used to Manually Activate my SQL Backup Pro Licenses, but I had not used it for the Compare Applications. When I attempt to Activate the license on the EC2 instance it requests that I login to my RedGate Account. Since I do not have Internet Access, I am stopped from getting any further with the activation process. As I feared, I will need internet access in order to activate my licenses. John R. / comments
  1. Community
  2. SQL Compare
  3. License Activation for SQL Compare 13 without Internet Access
Alex, Thanks, I guess this answers my questions. This is the Activation Web Page that I have used to Manually Activate my SQL Backup Pro Licenses, but I had not used it for the Compare Applications...
0 votes
Thank you again Alex, I have one additional comment to add for any RedGate Tech that may see this post. I installed a version update on my desktop to my Oracle Compare that required me to reactivate my license. I was not able to activate the license even though I was logged into RedGate.com, I did get the manual activate screen and was able to successfully activate the license. This says to me that internet access is required to activate licenses, either automatically or manually. John R. / comments
  1. Community
  2. SQL Compare
  3. License Activation for SQL Compare 13 without Internet Access
Thank you again Alex, I have one additional comment to add for any RedGate Tech that may see this post. I installed a version update on my desktop to my Oracle Compare that required me to reactivat...
0 votes
Jessica, I have the latest release of Search (2.4) and have recently installed the latest release of SSMS 17.0 but do not see the RedGate Tab on the Toolbar menu. Is there an additional step that I need to do to activate Search? John R. / comments
  1. Community
  2. SQL Search
  3. SQL Search doesnt work with SSMS 17
Jessica, I have the latest release of Search (2.4) and have recently installed the latest release of SSMS 17.0 but do not see the RedGate Tab on the Toolbar menu. Is there an additional step that I...
0 votes
Dan, I have run several days with the SQL Backup Patch (8.0.1.405) and have not had any errors. I consider this problem fixed. Thanks, / comments
  1. Community
  2. SQL Backup
  3. SQL Backup 8 - Thread Errors
Dan, I have run several days with the SQL Backup Patch (8.0.1.405) and have not had any errors. I consider this problem fixed. Thanks,
0 votes
Here is the Backup Log from one database that has failed 5 times since Version 8.0 was installed on 19 JUL 16. Not sure what you mean about the events leading up to the issue. We have a job that selects all online databases and backs them up one by one. This is the fourth backup of 20. All database before this one and all databases after this one was successful. SQL Backup log file 8.0.0.814 -SQL "BACKUP DATABASE [BI_TRN_NA_ODS] TO DISK = '\GPGBYDBDUMP02I$BACKUPSTier4CPGBYTRAND04_DEV@BI_TRN_NA_ODS@FULL@20160730@030122.sqb' WITH CHECKSUM, COMPRESSION = 2 " ERRORS AND WARNINGS 7/30/2016 3:01:22 AM: Backing up BI_TRN_NA_ODS (full database) on DEV instance to: 7/30/2016 3:01:22 AM: \GPGBYDBDUMP02I$BACKUPSTier4CPGBYTRAND04_DEV@BI_TRN_NA_ODS@FULL@20160730@030122.sqb 7/30/2016 3:01:23 AM: BACKUP DATABASE [BI_TRN_NA_ODS] TO VIRTUAL_DEVICE = 'SQLBACKUP_D0A530AB-8F87-4843-BFC5-76859CB2BD7B' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (BI_TRN_NA_ODS), 7/30/2016 3:01:22 AM', DESCRIPTION = N'Backup on 7/30/2016 3:01:22 AM Server: CPGBYTRAND04DEV Database: BI_TRN_NA_ODS', FORMAT, CHECKSUM 7/30/2016 3:01:25 AM: Thread 0 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) 7/30/2016 3:01:25 AM: 7/30/2016 3:01:26 AM: SQL error 3013: BACKUP DATABASE is terminating abnormally. 7/30/2016 3:01:26 AM: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_D0A530AB-8F87-4843-BFC5-76859CB2BD7B:" 995(The I/O operation has been aborted because of either a thread exit or an application request.). 7/30/2016 3:01:26 AM: SQL error 1222: Lock request time out period exceeded. 7/30/2016 3:01:26 AM: SQL error 5901: One or more recovery units belonging to database 'BI_TRN_NA_ODS' failed to generate a checkpoint. This is typically caused by lack of system resources such as disk or memory, or in some cases due to database corruption. Examine previous entries in the error log for more detailed information on this failure. / comments
  1. Community
  2. SQL Backup
  3. SQL Backup 8 - Thread Errors
Here is the Backup Log from one database that has failed 5 times since Version 8.0 was installed on 19 JUL 16. Not sure what you mean about the events leading up to the issue. We have a job that se...
0 votes
Dan, I have deployed the change to several of the servers that were failing consistently. So far I have not had any recurrence of the thread issue. If I have no problems in the next few days, I will be redeploying to my development environment next week. Thanks, / comments
  1. Community
  2. SQL Backup
  3. SQL Backup 8 - Thread Errors
Dan, I have deployed the change to several of the servers that were failing consistently. So far I have not had any recurrence of the thread issue. If I have no problems in the next few days, I wil...
0 votes
The backup error does show that this is an SQL Error. However, these errors did not occur in SQL Backup Editions 7.7 and earlier. Now with SQL Backup 8.0, I have 1 - 4 failures each night from different servers. The backup job will backup several databases successfully, then one database backup will fail with a RedGate 790, then the remaining databases will backup successfully. I have also conducted additional testing and have found that setting Minimum Memory for the SQL instance has eliminated most of these errors, but I still have errors on several servers during the week. And even this change does not eliminate the problem on some servers. / comments
  1. Community
  2. SQL Backup
  3. SQL Backup 8 - Thread Errors
The backup error does show that this is an SQL Error. However, these errors did not occur in SQL Backup Editions 7.7 and earlier. Now with SQL Backup 8.0, I have 1 - 4 failures each night from diff...
0 votes
I added the reqistry entry for VDITimeout. Apparently it was not enough time to correct the error. I have changed it to 90 seconds. By changing the registry setting, I am now getting the VDI 1010 error. And I am see where the backup is being retried and succeeding. John Rice / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Errors 3201 & 3041 appear in Error Log
I added the reqistry entry for VDITimeout. Apparently it was not enough time to correct the error. I have changed it to 90 seconds. By changing the registry setting, I am now getting the VDI 1010 e...
0 votes
Total activity
22
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
4