How can we help you today? How can we help you today?
NeM
Activity overview Badges (0) Posts (7) Comments (11)

Comments

Sort by recent activity
Yes, the patch fixed my issue too. Thanks Neil. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Cant use SSMS 2012 after updating from 10.1 to 10.2
Yes, the patch fixed my issue too. Thanks Neil.
0 votes
FYI, this is their email response: "This is a known issue. We have identified the problem and aim to release a fix next week. Week commencing 21st May 2012. We apologise for any inconvenience caused by this issue." / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Cant use SSMS 2012 after updating from 10.1 to 10.2
FYI, this is their email response: "This is a known issue. We have identified the problem and aim to release a fix next week. Week commencing 21st May 2012. We apologise for any inconvenience cause...
0 votes
I see this same issue too with the exact same error message as above. It is incredibly annoying to get this popup message inside SSMS 2008. At first, I thought this was an issue with SQL Data Compare 10 which was where I posted this issue first on that forum. Now I think this is an issue with SQL Compare 10.2.0.696. Here are my client specs: Microsoft SQL Server Management Studio 10.0.5500.0 Microsoft Analysis Services Client Tools 10.0.5500.0 Microsoft Data Access Components (MDAC) 6.1.7601.17514 Microsoft MSXML 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 9.0.8112.16421 Microsoft .NET Framework 2.0.50727.5456 Operating System 6.1.7601 (Windows 7 Professional 64bit SP1) / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Cant use SSMS 2012 after updating from 10.1 to 10.2
I see this same issue too with the exact same error message as above. It is incredibly annoying to get this popup message inside SSMS 2008. At first, I thought this was an issue with SQL Data Compa...
0 votes
This is resolved. The patch release for SQL Compare 10.2.0.777 fixed this issue for me. Thanks. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Getting "Unhandled exception has occured.." message
This is resolved. The patch release for SQL Compare 10.2.0.777 fixed this issue for me. Thanks.
0 votes
It looks like this may not be an issue with SQL Data Compare but it may be an issue with SQL Compare 10.2.0.696. Looking over at that forum, I see someone else has a similar issue to mine. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Getting "Unhandled exception has occured.." message
It looks like this may not be an issue with SQL Data Compare but it may be an issue with SQL Compare 10.2.0.696. Looking over at that forum, I see someone else has a similar issue to mine.
0 votes
I checked "%programdata%\Microsoft\SQL Server Management Studio\11.0\Addins" and the only add-in in there is "RedGate.SQLPrompt.SSMSUI.2011.AddIn" in mine. I'm hesitant to remove it unless RedGate recommends it - I'll wait for their reply. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Getting "Unhandled exception has occured.." message
I checked "%programdata%\Microsoft\SQL Server Management Studio\11.0\Addins" and the only add-in in there is "RedGate.SQLPrompt.SSMSUI.2011.AddIn" in mine. I'm hesitant to remove it unless RedGate ...
0 votes
Eddie, here is the info you requested: Microsoft SQL Server Management Studio 10.0.5500.0 Microsoft Analysis Services Client Tools 10.0.5500.0 Microsoft Data Access Components (MDAC) 6.1.7601.17514 Microsoft MSXML 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 9.0.8112.16421 Microsoft .NET Framework 2.0.50727.5456 Operating System 6.1.7601 (Windows 7 Professional 64bit SP1) / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Getting "Unhandled exception has occured.." message
Eddie, here is the info you requested: Microsoft SQL Server Management Studio 10.0.5500.0 Microsoft Analysis Services Client Tools 10.0.5500.0 Microsoft Data Access Components (MDAC) 6.1.7601.17514...
0 votes
Not a bug - I was missing something obvious. The source environment had its DDL trigger disabled as well which was probably why the destination environment failed to show the sql statement to re-enable the DDL trigger. After re-enabling the DDL trigger in the source, the destination sync script did produce the re-enable DDL trigger sql statement. Sorry - false alarm. [image] / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Version 9.0.0.79 does not re-enable DDL triggers after sync
Not a bug - I was missing something obvious. The source environment had its DDL trigger disabled as well which was probably why the destination environment failed to show the sql statement to re-en...
0 votes
Thanks for your input petey. I'll try that suggestion. I suspect it might be the network throughput between the 2 servers and not the load on the restore server itself. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Restore process has erratic speed fluctuations
Thanks for your input petey. I'll try that suggestion. I suspect it might be the network throughput between the 2 servers and not the load on the restore server itself.
0 votes
Thanks petey for your reply. Here are the logs for the slowest and fastest nights. Fastest night on Feb 8th: SQL Backup log file 6.4.0.56 -SQL "RESTORE DATABASE [MyDB] FROM DISK = '\\BKUP\Nightly_Full\FULL_(local)_MyDB_20110208_020226.sqb' WITH RECOVERY, MOVE 'MyDB_Data' TO 'E:\Data\MyDB_data.mdf', MOVE 'MyDB_Log' TO 'E:\Log\MyDB_log.ldf', REPLACE, MAILTO_ONERROR = 'dba@email.com', THREADPRIORITY = 6 " PROCESSES COMPLETED SUCCESSFULLY 2/8/2011 4:34:06 AM: Restoring MyDB (database) from: 2/8/2011 4:34:06 AM: \\BKUP\Nightly_Full\FULL_(local)_MyDB_20110208_020226.sqb 2/8/2011 4:34:06 AM: RESTORE DATABASE [MyDB] FROM VIRTUAL_DEVICE = 'SQLBACKUP_D0433D67-5A3F-4C91-B97D-AD3C6DE3910F', VIRTUAL_DEVICE = 'SQLBACKUP_D0433D67-5A3F-4C91-B97D-AD3C6DE3910F01', VIRTUAL_DEVICE = 'SQLBACKUP_D0433D67-5A3F-4C91-B97D-AD3C6DE3910F02' WITH BUFFERCOUNT = 18, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , RECOVERY, MOVE 'MyDB_Data' TO 'E:\Data\MyDB_data.mdf', MOVE 'MyDB_Log' TO 'E:\Log\MyDB_log.ldf', REPLACE 2/8/2011 6:27:38 AM: Processed 14817152 pages for database 'MyDB', file 'MyDB_Data' on file 1. 2/8/2011 6:27:38 AM: Processed 56 pages for database 'MyDB', file 'MyDB_Log' on file 1. 2/8/2011 6:27:38 AM: RESTORE DATABASE successfully processed 14817208 pages in 6803.218 seconds (17.841 MB/sec). 2/8/2011 6:27:38 AM: SQL Backup process ended. 2/8/2011 6:27:38 AM: Deleted msdb entries older than 11/10/2010 6:27:38 AM 2/8/2011 6:27:38 AM: Deleted local history entries older than 11/10/2010 6:27:38 AM Slowest night on Feb 14th: SQL Backup log file 6.4.0.56 -SQL "RESTORE DATABASE [MyDB] FROM DISK = '\\BKUP\Nightly_Full\FULL_(local)_MyDB_20110214_020121.sqb' WITH RECOVERY, MOVE 'MyDB_Data' TO 'E:\Data\MyDB_data.mdf', MOVE 'MyDB_Log' TO 'E:\Log\MyDB_log.ldf', REPLACE, MAILTO_ONERROR = 'dba@email.com', THREADPRIORITY = 6 " PROCESSES COMPLETED SUCCESSFULLY 2/14/2011 2:36:49 AM: Restoring MyDB (database) from: 2/14/2011 2:36:49 AM: \\BKUP\Nightly_Full\FULL_(local)_MyDB_20110214_020121.sqb 2/14/2011 2:36:49 AM: RESTORE DATABASE [MyDB] FROM VIRTUAL_DEVICE = 'SQLBACKUP_72110CCA-A1CC-48F6-9145-201A2818C995', VIRTUAL_DEVICE = 'SQLBACKUP_72110CCA-A1CC-48F6-9145-201A2818C99501', VIRTUAL_DEVICE = 'SQLBACKUP_72110CCA-A1CC-48F6-9145-201A2818C99502' WITH BUFFERCOUNT = 18, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , RECOVERY, MOVE 'MyDB_Data' TO 'E:\Data\MyDB_data.mdf', MOVE 'MyDB_Log' TO 'E:\Log\MyDB_log.ldf', REPLACE 2/14/2011 4:54:31 AM: Processed 14865624 pages for database 'MyDB', file 'MyDB_Data' on file 1. 2/14/2011 4:54:31 AM: Processed 1 pages for database 'MyDB', file 'MyDB_Log' on file 1. 2/14/2011 4:54:31 AM: RESTORE DATABASE successfully processed 14865625 pages in 8258.624 seconds (14.745 MB/sec). 2/14/2011 4:54:31 AM: SQL Backup process ended. 2/14/2011 4:54:32 AM: Deleted msdb entries older than 11/16/2010 4:54:31 AM 2/14/2011 4:54:32 AM: Deleted local history entries older than 11/16/2010 4:54:31 AM / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Restore process has erratic speed fluctuations
Thanks petey for your reply. Here are the logs for the slowest and fastest nights. Fastest night on Feb 8th: SQL Backup log file 6.4.0.56 -SQL "RESTORE DATABASE [MyDB] FROM DISK = '\\BKUP\Nightly_F...
0 votes
Total activity
23
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
5