Hi,

That's as I thought, shrink the primary and the secondary will shrink, I'll try it out in a very small size reduction and see.

Thanks for your reply.

Nic

So I built a test for this which did the following;

1. Create a database

2. Insert 2 records into a table and take a full backup (FB1).

3. Insert 2 more records...

Hi,

Thanks for the reply, yes I could but I was trying to avoid that if I could but I think it may have to be that.

I just don't buy that...

Hi,

I've come up with a solution to this (in part). The MDS data is synced over to another system via an SSIS package. In the package I bring over the...

Not at all.

The issue for me was that the account the SSAS agent was running as had a default language of 'English' in the database engine, so when it was...

I think I've got this, it was an incorrect service account config.

All though no one replied, thank you to those who took the time to read the post.

Thanks,

Nic

Hi,

Thanks for the replies, I think your right, doing this in a data flow task may be more trouble than its worth, I'm leaning now to instead having an SSIS...

Hi,

The problem is that we want to be able to map new files without having to change the SSIS but instead do it via data mapping tables.

Kind of like ...

Hi,

Just an update on where I am with this, in short I've developed a database which we use for housekeeping, in my estate it resides on each server but you...

Hi,

I've not forgotten about this, I've just been busy, I'll do my best to get an article together with scripts in the next week or so.

Sorry for the delay.

Nic

I've taken so much from this site and the SQLcommunity that it be my pleasure to try and put something back by contributing.

I'll get something typed up and submitted.

Thanks,

Nic

Yes, it records the start and end time for each statistic and also the sample rate it used and the method, rows or percent.

It also allows for specifying scan details...

Thank you all for the comments, using them I've built a robust customisable housekeeping script for all our statistics with suitable auditing included.

Thanks again,

Nic

Hi,

Thank you both for your response, I think I'm going to go with a straight forward SAMPLE by default and let SQL decide based on the table size, but allow...

Hi Leonard,

Thanks for this whilst this is an excellent script for people without anything or looking to add to existing maintenance.

From what I can see the @SampleStatistics parameter is set...