Thanks for the replies!

Permissions are set up on the folder and yes Jeff, it is via a stored procedure and sa is disabled too 🙂

Thanks Gail, sadly it gives a not permitted error. Looks like it is the restores then, although presumably as it error sits in IO its only a matter of...

Gail you are by far my favourite superhero!

Yes I tried that initially and that didn't work and doing it since shows that a restore was interrupted and errors again. ...

Would the OLEDB driver work instead?

Actually, thinking I can get those from exec_query_plan perhaps?

Well, their monitoring software but yes, that's my next call!

Thanks again Gail!!

Thanks Gail, that's what I thought.

For some reason though Idera is saying its SP2 CTP and unsupported!

David

Yes of course I looked on BOL, I was just after some confirmation really after posting the command. However, I didnt put any of that in my 2nd post...

Can I do this on the mirror?

ALTER DATABASE<Databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

Apologies for the rather hasty copy and paste snippets that weren't exactly workable and thank you for the reply. The query is rather mammoth in size and I was...

Hi and many thanks for the reply.

Understand the concepts I think what I am trying to get my head around is that I can have a 3 node...

Resolved - apologies - all to do with SID history! 🙂

Thanks the reply and confirming my thoughts. I didnt think that would be the case but I'll always go on the 'never know until someone confirms'...thanks again.

Yes I did find that the training kits (either in a book or software) are really good to get a feel for the questions. Most of the books that...

Personally, I would always recommend some of the books/kits.

I worked with 2005 on a daily basis prior to taking the exam but I still bought the books and training kits....