Activity overview
Latest activity by DBA_Dave
petey wrote:
To mdgraves, SQL Backup does not change any SQL Server registry settngs during installation or upgrades.
It may not change any registry settings, but it sure changed the destination of several of my backups to the Windows default folder rather than the dedicated SAN disk I had been pointing at.
I found out when the drives filled... Now I make sure to check every job after an upgrade to make sure the drive stays the same. / comments
petey wrote:
To mdgraves, SQL Backup does not change any SQL Server registry settngs during installation or upgrades.
It may not change any registry settings, but it sure changed the destinati...
I don't have any problems inserting to or selecting from this partitioned table.
The table has both a clustered index and a covering index on the time column used in the partition function. Nothing needs to be arranged. / comments
I don't have any problems inserting to or selecting from this partitioned table.
The table has both a clustered index and a covering index on the time column used in the partition function. Nothin...
ZLIB is free open source code. Everyone has access to it: http://www.zlib.net/
(The Copyright strings are in your DLL's) / comments
ZLIB is free open source code. Everyone has access to it:http://www.zlib.net/
(The Copyright strings are in your DLL's)
Unhandled exception in backup
This may be a regression bug. It was fixed back at 3.2.0.10, according to a post in the forum.
There are about 70 more databases on the server, they all backed up without error. They are being ba...
The service can be set to restart, but not to affect the group. It can't be put in as a dependency on a resource without taking that resource offline, so there should be no attempt to do so.
The default should be the safe option. The installer does not appear to be able to cleanly start the new service, and even if that were not the case, the only correct answer is to "first, do no harm". / comments
The service can be set to restart, but not to affect the group. It can't be put in as a dependency on a resource without taking that resource offline, so there should be no attempt to do so.
The d...
I am using a date column, not the PK. This is for financial data that needs to be organized by quarters and years.
I can email the schema, I can't make it public. / comments
I am using a date column, not the PK. This is for financial data that needs to be organized by quarters and years.
I can email the schema, I can't make it public.
Compare fails for partitioned tables
I have been trying to compare two different cases in SQL 2005 SP2:
1. A non-partitioned table to its partitioned twin on another server.*
2. A partitioned tabled to its partitioned twin on anothe...
Extremely Dangerous Cluster Setting on New Backup Agent.
I just installed the latest server components onto a cluster server. The service was added as a cluster resource, something I could have done without, and then it did the inexcusable: It set the ...
I deinstalled the tools via Control Panel on those servers and that fixed the problem. / comments
I deinstalled the tools via Control Panel on those servers and that fixed the problem.
The two servers are ones that already had components installed but were not currently attached to my console. And they are clustered. / comments
The two servers are ones that already had components installed but were not currently attached to my console. And they are clustered.