lol, i'll have a go later while i'm stuck in the airport waiting to see if my flight gets cancelled due to snow or not

I don't know exactly but we have been speaking to BT about something similar and they have indicated that we should be able to buy the license in Canada (or...

I'd say that the native backup compression depends upon the amount of free space in the data pages (fill factor related), it seems sensible that SQL wouldn't want to back...

I haven't seen this particular problem during an upgrade (we upgraded our clustered production systems to SP4 the other week), however, I have seen similar problems along these lines in the...

great, although that particular sue could be anyone, how do i know it's not someone else 

lol

Hi Sushila,

I do have to admit that it took me a little while before i managed to get that score (only a couple of days tho).

#5 already, i'll really have...

it might be nice to actually see the Stored procedure you're wanting help debugging

I agree, one of our DB's is a couple of TB with around 30000 users and has heavy temp table usage, our TempDB is set to 20GB (4*5GB) and as...

From the sounds of it you need to script up the attach rather than using EM to do it, this will then recreate the missing log file (hopefully).

Thanks for that Colin, i'll have a look and see if it's applicable to my problem

Thanks Ian, that makes sense

Hi Steve,

I can't think of anything worse than having a very sick child; i've got two kids at home and whilst they're both healthy I know that i'd move heaven...

We use clustering in production and log ship to a secondary site to maintain a standby server, this gives us the best of both worlds in my opinion.

To be honest...

Hi, just a quick note to say that this is totally normal, the active/passive setup indicates that only one of the nodes is active at any one time.

As for whether...

Hi John,

Are you planning on building solutions for others, hosting them yourself or just working on problems for people?

If it's one or three then you should be fine with the...