Thanks for getting back guys, preumably this would be different if you wanted the sa account to be the owner of scheduled agent jobs, I'd imagine they would fail if...

Hello, thanks for getting back.

Its a bog standard domain account that has 'log on as a service' right on the local machine. I was under the impression that changing the...

Marrrrvelous!

Thank you very much!

Regards,

D.

Hello,

Well, the first account I logged on as was my own and the domain admin, both of which have (or at least had) domain and sysadmin privs. So I am...

Hey thanks for getting back. I actually decided to try logging on as the local admin and everything came back as normal. I guess I will try dis-joining it from...

Hey,

Thank you for replying to my thread, basically I got the perfect answers.

Thanks guys.

Regards,

D.

Thanks for getting back, currently its the local admin account.

Hello,

No there is no login as dbo, I should have checked this beforehand. Do I create one the same way as any other user and issue it sysadmin privs?

Regards,

D.

Hello,

Yep that looks good, I have actually used this before, but didnt realise it was multi-user.

Cheers,

D.

Great, thank you!

Regards,

P.

I have never had an employer pay for training, its all been done in my own time and at my own expense. However, I am feeling a bit disillusioned, as...

Silverfox,

I can see that there is indeed to a double \\ in the file path for some reason, I cant see how this can happen as I am using the...

Hello

Thanks for getting back, all of my DB's are in full recovery mode. Here is the log that will hopefully help you to help me. Hope its right.

Failed:(-1073548784) Executing the...

Hi there,

I sent you a PM on this, did you receive it ok? I'm not sure if it went through or not.

Regards,

D.

Thank you Gail,

Would definatly take a backup beforehand, I'll check out the rows and see whats what, doesnt look as if its too bad.

Thank you for your help, your a...