Viewing 15 posts - 121 through 135 (of 263 total)
Absolutely no reason to be on this level. Oversight I guess from the previous DBA.
It's been fully tested on the correct Compatibility but the CAB wont authorise the...
April 3, 2017 at 5:57 am
And looking at the backup history in msdb also confirms that its a full backup that was created even though differentil was specified.
April 1, 2017 at 9:10 am
I can report back that the odd behaviour is recreatable.
Cancel a full backup and the next diff and subsequent diffs are in fact FULL backups in terms of...
March 31, 2017 at 1:40 pm
So looking through backupset and backupmediafamily has highlighted the naughty person who forgot to add 'copy_only' when doing an adhoc commvault backup!
He has been ridiculed and taunted.
March 31, 2017 at 12:33 pm
Good point, it is being log shipped too... But I just double checked to rule out any crazy and can confirm its FULL.
It is in 2005 Compatibility Mode....
March 31, 2017 at 9:47 am
March 30, 2017 at 12:19 pm
March 30, 2017 at 12:14 pm
I am back with another ignorant question.
How exactly does on read / interpret the results of show_statistics...
This is sample out from the histogram (pardon the bad...
March 30, 2017 at 6:01 am
I am part way through doing Option 4 on a different database on dev to see if it is repeatable behaviour.
A full backup on there is consistently 50GB.
March 30, 2017 at 5:56 am
Are you thinking there are multiple backups to the device? the backup is performed with init...
March 30, 2017 at 5:25 am
is there a DMV that will tell me the last sample rate used?
March 30, 2017 at 4:10 am
No, its very peculiar and I have seen this behaviour before at a previous place on 2008R2 but didn't pay it much mind as it was a small database (<...
March 30, 2017 at 4:06 am
Right. So an automatic update is ever only a sampled scan then?
March 30, 2017 at 1:13 am
I think perhaps that *where* you work over what it is you do has a bigger impact on job satisfaction.
I love what I do for the past 3...
March 30, 2017 at 1:12 am
Steve, cheers for that! I had not considered read-only work loads for a second...
Brilliant, thanks again!
Alex
March 29, 2017 at 2:33 pm
Viewing 15 posts - 121 through 135 (of 263 total)