Have you configured a default instance?

Are you able to connect to Management Studio?

Database is in Full recovery model and you are not taking t-log backup right?

Nice question, thanks.

I agree with you Brandie. Thank you.

Craig Farrell (4/14/2011)

---

mohammed moinudheen (4/14/2011)

---

Craig, thank you very much for the article. This would be very helpful for most of us.

I have seen many job postings which requires people...

Thanks Lynn and Craig, I got a lot of points from your comments.

I didn't mean to trouble you folks though, it is kind of tough to work on these types...

I was doubtful while answering this question as Tax Day has been extended to April 18 this year.

However, all the rest of the options were not good enough to be...

But only this job fails sometime between 10:00 PM to 11:00 PM.

It is scheduled to run every 5 minutes though.

This is a tough one really 🙂

Craig, thank you very much for the article. This would be very helpful for most of us.

I have seen many job postings which requires people knowledgebale in other database...

Thanks Utpal for letting me know

Good question, but tough to get it right 🙂

Thanks for the question.

M Joomun (4/11/2011)

---

I have a question regarding backing up the transaction log for a production db. How often does this need to be done? Every day or more or less...

Thanks for a good question.