Comments
Sort by recent activity
I changed my SQL Server service to use the LocalSystem account, and I was able to install the server components. Once everything was installed, I switch the SQL Server service back to my preferred account. The backups are running fine.
Just curious, did you remove the "BUILTIN\Administrators" group from your SQL Server instance? I always do, and I am wondering if Red-Gate expects you to be using a service account that is also a member of the Windows Local Administrators group. That might explain why we had to use LocalSystem to complete the installation.
If that is the case, I think Red-Gate should reconsider. There are many situations in which you would not want members of the LocalAdministrators group to have sysadmin privileges on instances of SQL Server. / comments
I changed my SQL Server service to use the LocalSystem account, and I was able to install the server components. Once everything was installed, I switch the SQL Server service back to my preferred...
Hmm ... let me see if I can install it with the LocalSystem account. / comments
Hmm ... let me see if I can install it with the LocalSystem account.
I'll speak to the developer, she may be able to modify it to implement IComparable. Thanks for the assistance! / comments
I'll speak to the developer, she may be able to modify it to implement IComparable. Thanks for the assistance!
The tables in question are in two different schemas. All but one of the tables that work are in one schema, and all of the tables in this schema have primary keys. The tables in the other schema do not have primary keys, so I have to create a custom comparison key for each table that includes all columns in the table. / comments
The tables in question are in two different schemas. All but one of the tables that work are in one schema, and all of the tables in this schema have primary keys. The tables in the other schema ...
I caputure the SQL statements in Profiler, and I was able to run them all in Management Studio. As for the comparison key, it is not included for the tables that have a primary key, but it IS included for the tables that do NOT have primary keys. / comments
I caputure the SQL statements in Profiler, and I was able to run them all in Management Studio. As for the comparison key, it is not included for the tables that have a primary key, but it IS incl...
richardjm wrote:
We do support comparison of CLR data types. We also support their transport as binary - of course your CLR types would have to be binary compatable.
HTH
Well, I did double check my version, and I realized I was not using version 6. However, even after I upgraded, I am still getting an error for one of my CLR types. This is odd behavior because this same type appears in other tables in the same database, and the new version had no problem with them.
This is the error message: The type "UserInformation" is not comparable. It cannot be used in the ORDER BY clause."
I am going to post this issue in the troubleshooting forums. / comments
richardjm wrote:
We do support comparison of CLR data types. We also support their transport as binary - of course your CLR types would have to be binary compatable.
HTH
Well, I did double che...
I'd like to have some mechanism to allow the comparison of tables with CLR data types. These data types are going to become more and more common over time, and the inability to process these data types is a major headache in my environment. / comments
I'd like to have some mechanism to allow the comparison of tables with CLR data types. These data types are going to become more and more common over time, and the inability to process these data ...
Okay, that's a start.
I have been trying the backups using multiple threads, but now I see this would be a bad idea if memory is the issue.
Just to clarify, will SQL Backup retry multiple times until it gets down to 65,536, as shown here ...
1st Try 1048576
2nd Try 524288
3rd Try 262144
4th Try 131072
5th Try 65536
... or does it only retry once at half the value of MAXTRANSFERSIZE?
1st Try 1048576
2nd Try 524288 / comments
Okay, that's a start.
I have been trying the backups using multiple threads, but now I see this would be a bad idea if memory is the issue.
Just to clarify, will SQL Backup retry multiple times unt...
That works for me. I just wanted to get on the list of future fixes. / comments
That works for me. I just wanted to get on the list of future fixes.
I can live with it. At least I know it's not something wrong with my installation. / comments
I can live with it. At least I know it's not something wrong with my installation.