Hello,

Thanks for getting back, I cannot get a restore done that quickly, but its in motion, I'll check out the link now.

Regards,

D.

Hello,

I think the SPID is blocking up the Tempdb database, I'm wondering if perhaps I need to just restart the instance to get round this. If I run DBCC Opentran('tempdb')...

I could not do the backup because I could not get a lock on the database. So I have taken the decision to kill the process, currently it is in...

Ok, but if I do that how will that help the production one currenlty being used? I think I MIGHT know what the issue is, there appears to be a...

DAMMIT! Thats twice now! Its like I'm talking to myself! Again!

Well done, what materials did you use, and how long for study?

Regards,

D.

How was it amusing?

Yes, you cant not make an appointment. Had E-mail confirmation, the lot. Rang the test centre number as well, but got answer because obviously nobody was there.

D.

Hello Everyone,

I have been studying for a few months for the 70-448 exam, in the last week I was cramming well into the early hours for last Saturdays exam, I...

Hello,

I'm sitting the 70-448 exam very soon, for those if you who have sat it, was there any areas of the exam that you struggled on because there was a...

Hello Gail,

After reapplying the permissions for the Engine and Agent to the log and database files, I did as you said, and brought the databases back online. Yes, why did...

Yes, I had a feeling it might something to do with permissions, the files are there, when I try to bring the database online I get the following error message...

Msg...

Perfect, thank you very much.

Regards,

D.

Hey there,

Thank you Gail and GSquared, I try everything you have given me, hopefully I should be ok. Much appreciated.

Kind Regards,

D.

HI GSquared, sorry yes, the database roles, not the server roles.

Regards,

D.