Would love a link to it too if anyone has one please ?

Ed B, you are as clever as I was dim.

Great spot and thank you very much !

HanShi...

No problem Steven.

In the end I just used a different server running the same version of SQL.

Thanks Dan, that's good advice.

In answer to your questions

We'd be less than 150 users with a couple of hundred reports.

It's a front-end and back-end together box.

Thanks Anthony - I realise each server's workload (and therefore requirements) vary but I'm still interested in what specs are being used.

Thanks for your point on CPU, and what, may...

Don't be shy folks, 32 views and no posts ?

I'd like to get an idea of what the range of production box specs are out there please ?

Similar issue folks - CREATE statements being logged, DROP statements not ?

Hey folks,

Thank you so very much for your help.

Minus at least one point for me for not finding that myself :blush:

There is another DBA - I'm going to get my...

Hi Syed,

I don't have a bespoke History Purge job but I do run the standard "Cleanup History" that's part of the maintenance plan.

This runs @ 3 AM though, that...

I'll have to warn you - we're auditing successful logins and our main user app connects/disconnects very often so there'll be a good bit of scrolling ...

Anyway, here's the log...

Thanks Gail !

We're using SQL 2008

I don't get any results when I filter the relevant SQL Logs for "Setting database option RECOVERY"

Further weirdness - there's nothing in the log for...

Forgot to say, native backups only so the cause isn't as below

http://social.msdn.microsoft.com/Forums/en/sqltools/thread/13e7a89e-bc75-492c-98c6-24e4158f76c3

The server's located in Ireland - as am I.

Good...

Please excuse if this is a silly suggestion but is there a log file (XXX.ldf) on the same drive or is there just the XXX.mdf file ?

I often use the...

PaulB-TheOneAndOnly (11/29/2010)

---

Joseph Fallon (11/29/2010)

---

PaulB-TheOneAndOnly (11/29/2010)

---

Joseph Fallon (11/29/2010)

---

Hi Pablo,

Thanks for the post.

I'm not too worried about the VB side of things ... all I need is for the Expression that I...