Activity overview
Latest activity by integragroup
SQL Backup Performance Difference between 32bit to 64bit
We are trying to understand a performance difference we noticed when recently moved from SQL 2000 (32bit) to SQL 2008 R2 (64bit).
A db that is 105GB was taking 2 1/2 hours to backup to a network dr...
Did a quick test and it looked like it was going to work. Will perform additional tests today and will report back if anything new develops. / comments
Did a quick test and it looked like it was going to work. Will perform additional tests today and will report back if anything new develops.
It appears this could be related to SQL Server 2000.
We are in the process of migrating over to 2008 so I tested it between 2 dbs on the 2008 server and it behaved as desired.
I don't get an error, I get the "New Database" prompt indicating "The target database you specified does not exist".
The interesting thing here is the Database Name is the name of the Source database for the comparison. / comments
It appears this could be related to SQL Server 2000.
We are in the process of migrating over to 2008 so I tested it between 2 dbs on the 2008 server and it behaved as desired.
I don't get an error,...
version 10 - tries to create db for remote dbs
Just updated to v 10. Tried to compare two remote databases that I had compared multiple times with v 9.x and now v10 is saying "New Database", the target database you specified does not exist.
I s...