Viewing 15 posts - 271 through 285 (of 614 total)
page count on those indexes varies from 5 up to 2700, fragmentation from 44-86% and all are index_level 1 or 2 in the report I'm talking about. When...
April 23, 2012 at 12:34 pm
We already handle the index_level=0 indexes in a rebuild/reorganize stored procedure. If the index_level is not zero we've been ignoring them. A new DBA is reporting higher than 30%...
April 23, 2012 at 12:06 pm
but the system databases are on the c drive. I finally confirmed that the iscsi drives are on a separate server. Its possible the corruption was...
April 19, 2012 at 8:35 am
I don't know how its setup but when I look in task manager on the sql server I see:
Fabric A1 Port 2 160 Subnet
Fabric B1 Port 2 ISCSI
The Microsoft iSCSI...
April 17, 2012 at 9:46 am
The full index rebuild made it about 95% through before bombing. dbcc checkalloc revealed allocation errors in several tables. So, hopefully since this is a test environment...
April 16, 2012 at 7:27 am
Yes, seemed bizarre to me. Depends on what management wants I suppose. If up-time is more important than anything else, then..... Patches can be tested however,...
January 31, 2012 at 10:40 am
Yes so this leaves us with an eight-hour window where if the backup job fails our only good backup is in Commvault. If there has been no outage, you...
January 18, 2012 at 6:12 am
Yes, just tested this by attempting to do a backup of a database onto an existing BAK file of about 20GB. After 20 seconds I killed the backup command...
January 17, 2012 at 5:44 pm
If during an 8-hour full backup the job fails, leaving neither the new backup nor the previous one with the same file names usable, then you have to write out...
January 17, 2012 at 8:56 am
It would nice to get more feedback on this.
January 17, 2012 at 7:17 am
Well we do have the backup of the backups on commvault, but this seems like a flawed job design where if the new full backup process fails, neither the new...
January 16, 2012 at 9:39 am
Thanks !!!
November 25, 2011 at 10:23 am
The problem is that the master database appears to be back at RTM but the resource database shows SP4. Both of those are on a shared storage drive --...
November 25, 2011 at 9:19 am
If you have an "account" number and other fields where the GUI allows the user to search with LIKE ( contains.....), and you have to encrypt that account...
August 4, 2011 at 1:52 pm
Viewing 15 posts - 271 through 285 (of 614 total)