How can we help you today? How can we help you today?
Jason Hannas
Activity overview Badges (0) Posts (12) Comments (25)

Comments

Sort by recent activity
Same problem when upgrading from 5.0 to 5.1 -- did you or anyone else find a resolution? / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Error upgrading from 5.0 to 5.0.3
Same problem when upgrading from 5.0 to 5.1 -- did you or anyone else find a resolution?
0 votes
Follow up--it's been a week and have not experienced the error. I'll chalk it up to file system contention at this point unless I see it again. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Process terminated unexpectedly. Error code: -2139684861 (Th
Follow up--it's been a week and have not experienced the error. I'll chalk it up to file system contention at this point unless I see it again.
0 votes
I have a similar situation...just began two days ago. There are 670 databases which get backed up on this job--most of them very small--and the past two nights, the job has failed on two different databases. A 2KB file is created, the below error is thrown, and the rest of the backups proceed normally. 4/28/2015 2:25:08 AM: Backing up <<DATABASE>> (differential database) to: 4/28/2015 2:25:08 AM: E:MSSQLBackup<<DATABASE>><<SERVER>>_<<DATABASE>>_20150428_022508_DIFF.sqb 4/28/2015 2:25:09 AM: BACKUP DATABASE color=#408000]&lt;&lt;DATABASE&gt;&gt;[/color TO VIRTUAL_DEVICE = 'SQLBACKUP_86649A2B-AB64-472B-A80F-25A4B495F0DB', VIRTUAL_DEVICE = 'SQLBACKUP_86649A2B-AB64-472B-A80F-25A4B495F0DB01', VIRTUAL_DEVICE = 'SQLBACKUP_86649A2B-AB64-472B-A80F-25A4B495F0DB02' WITH BUFFERCOUNT = 18, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (<<DATABASE>>), 4/28/2015 2:25:08 AM', DESCRIPTION = N'Backup on 4/28/2015 2:25:08 AM Server: <<SERVER>> Database: <<DATABASE>>', FORMAT, CHECKSUM, DIFFERENTIAL 4/28/2015 2:25:14 AM: Thread 0 error: Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.) 4/28/2015 2:25:14 AM: 4/28/2015 2:25:14 AM: Thread 1 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) 4/28/2015 2:25:14 AM: 4/28/2015 2:25:14 AM: Thread 2 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) 4/28/2015 2:25:14 AM: 4/28/2015 2:25:14 AM: SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally. 4/28/2015 2:25:14 AM: SQL error 3201: SQL error 3201: Cannot open backup device 'SQLBACKUP_86649A2B-AB64-472B-A80F-25A4B495F0DB'. Operating system error 0x80770006(failed to retrieve text for this error. Reason: 317). Was there a resolution to this? My version is 7.7.0.7. Jason / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Process terminated unexpectedly. Error code: -2139684861 (Th
I have a similar situation...just began two days ago. There are 670 databases which get backed up on this job--most of them very small--and the past two nights, the job has failed on two different ...
0 votes
No, nothing was installed on that server in the past several weeks. I've adjusted my backup schedules so that transaction log backups are not being run during that time, to see if that may reduce file system contention. Since doing that, I've not seen the error. I'll check back in after a few days. Thanks / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Process terminated unexpectedly. Error code: -2139684861 (Th
No, nothing was installed on that server in the past several weeks. I've adjusted my backup schedules so that transaction log backups are not being run during that time, to see if that may reduce f...
0 votes
Ok...thanks for the response. I still don't know why the changes wouldn't save, but after rebooting, now it works--maybe some kind of goofiness with the write permissions on that registry key or something.... Thanks, Jason / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Changes to Backup Alerts won't save
Ok...thanks for the response. I still don't know why the changes wouldn't save, but after rebooting, now it works--maybe some kind of goofiness with the write permissions on that registry key or so...
0 votes
Yes, but I hadn't selected v2.0 -- my fault. (see below for: Version Information: Microsoft .NET Framework Version:1.1.4322.2490; ASP.NET Version:1.1.4322.2494 ) I didn't see that in the installation steps. May I suggest placing a sentance on http://www.red-gate.com/supportcenter/C ... M_UsingIIS under the heading "For IIS 6" under #3 which says something to this effect: h. Navigate to the ASP.NET tab and ensure the version selected is 2.0.50727. Thanks for the response! / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Parser Error Message: Unrecognized attribute 'type'.
Yes, but I hadn't selected v2.0 -- my fault. (see below for: Version Information: Microsoft .NET Framework Version:1.1.4322.2490; ASP.NET Version:1.1.4322.2494 ) I didn't see that in the installati...
0 votes
Thank you...that fixed my issue! / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Selection disappears after Format SQL
Thank you...that fixed my issue!
0 votes
I just came on the forums specifically to request this--it would be great if SQL Compare would also just allow you to click a loaded snapshot or even DB structure that was just read in for comparison purposes and generate SQL Doc documentation from it. / comments
  1. Community
  2. SQL Doc Previous Versions
  3. Feature Request - Source Connection properties
I just came on the forums specifically to request this--it would be great if SQL Compare would also just allow you to click a loaded snapshot or even DB structure that was just read in for comparis...
0 votes
I just upgraded using your link and confirmed that the problem is fixed with this update. Like an idiot, I did that before documenting the issue with screen shots, so if you think they'll be useful, I guess I could try to downgrade and reproduce. The version I was on that exhibited the problem is: 8.1.0.360. Checking for updates doesn't show any available, but I do see the OP was on 8.2 already. Let me know--if you'd like the screen shots, I'll downgrade and put it together for you. If not, just know that that version has a problem and the latest does not. Thanks, Jason / comments
  1. Community
  2. SQL Compare Previous Versions
  3. sql 2008 filtered indexes not detected in sql compare 8
I just upgraded using your link and confirmed that the problem is fixed with this update. Like an idiot, I did that before documenting the issue with screen shots, so if you think they'll be useful...
0 votes
I'm having the same issue as the OP. Steps to reproduce are: CREATE TABLE Test &#40; ColA int NOT NULL, ColB int NOT NULL, IsObsolete bit NOT NULL &#41; ; CREATE UNIQUE NONCLUSTERED INDEX ixTest_ColAColB_UN ON Test &#40;ColA, ColB&#41; WHERE ColB IS NOT NULL AND IsObsolete = 0 ; GO The resulting Compare output shows: -- Columns CREATE TABLE [dbo].[Test] ( [ColA] [int] NOT NULL, [ColB] [int] NOT NULL, [IsObsolete] [bit] NOT NULL ) GO -- Constraints and Indexes CREATE UNIQUE NONCLUSTERED INDEX [ixTest_ColAColB_UN] ON [dbo].[Test] ([ColA], [ColB]) GO This will have a major impact on synchronizing our dev and test environments. Please advise when a fix might be expected. If it helps any, SQL Doc catches the WHERE clause without a problem. Thanks. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. sql 2008 filtered indexes not detected in sql compare 8
I'm having the same issue as the OP. Steps to reproduce are: CREATE TABLE Test &#40; ColA int NOT NULL, ColB int NOT NULL, IsObsolete bit NOT NULL &#41; ; CREATE UNIQUE NONCLUSTE...
0 votes
Total activity
52
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
15