Hi - Many thanks for responding to my query. I've checked this and the box is ticked for Login is locked out. Is it just a case of unticking this...

Hi - Many thanks for the reply. Does this give me the number of user connections per DB or device connections?

Kind Regards

Dax

Hi - Many thanks for the reply. Is it best to run update statistics out of hours when there is no user activity and after a backup?

Regards

Dax

That's great, many thanks for the reply

Hi - That's great, many thanks for the advice. I tend to stop everything through Config Manager as I know stopping and starting through Win Services can cause issues.

Many thanks

Dax

Hi - Thanks for that, yes you're correct the UPS will last up to around 2hours. We thought the best approach would be to take SQL down cleanly, only if...

Hi - Many thanks for that, I will speak with our Tech Team to establish what's happening.

Hi - Thanks, I always use the configuration manager as I appreciate Windows can cause issues.

That's great, thanks for that

Hi - I do but that would mean changing the user account for the SQL Agent Service via configuration manager to use a doamin user, to give the appropriate rights...

Hi - No index work has been carried out on the DB. Would it be safe to run a differential on the DB? I have 49gb available on the drive...

Hi - Are you saying the chain would remain intact?

Many thanks

Dax

Hi - Many thanks for that, unfortunately I won't be able to make use of the compression as the DB is running on SQL2008 standard edition.

The mdf is 55,632,128kb...

Hi Gail - Many thanks for the reply.

Kind Regards

Dax

That's great, many thanks for the info. Much appreciated!

Kind Regards

Dax