GilaMonster (3/27/2012)

---

master's recovery model is always simple, regardless of what the actual database setting value is set to. It cannot ever have log backups taken or restored

Re log backups...

Thank you, Lynn, I'm reading it now.

Gail,

For me, this has been a great day of learning. I didn't know that MSDB stored jobs, job history, etc. Cool, thank you!

Concerning what our business needs are,...

Gail, I didn't realize that it may not be necessary to backup the transaction logs of system databases. WOW, interesting. OK, I'll remove that.

As you suggest, our database...

Good question, Lynn. I was't sure how the previous student DBA had set the recovery model for the system databases, so I just checked. He set it up...

Gail, what you said makes sense. When I was setting up a backup scheme on our test database server, I asked on these forums about how to do it....

I believe I may have been rude with the initial post of this thread. If in fact you found my initial post to be rude, then I am truly...

You've hit upon it. I was using a SQL role someone here created in the past called "mis". It owned the MgmtRpt schema that I created (I assigned...

That's good to know, Steve, thanks.

GSquared (3/20/2012)

---

I think there's a lot to this subject. It's not a simple situation.

For example, we don't graduate people from school with the skills of problem solving, interpersonal dynamics,...

Steve Jones - SSC Editor (3/20/2012)

---

Rod at work (3/20/2012)

---

Intriguing article, Steve, I'm going to follow this discussion with interest. I've only one, tangential thing to add; I've never gotten...

Intriguing article, Steve, I'm going to follow this discussion with interest. I've only one, tangential thing to add; I've never gotten a job in the prescribed way of networking...

Really? I had no idea. Thank you, Gail.

Never mind. It was my fault. My instance of SQL Server 2008 R2 Express is a named instance. I thought it wasn't. Oh well, excuse me while...

It's been a long time since I've had a good week. We're short staffed and loosing more staff next week. We're getting issues faster than we can solve...