Another question, which is related to this issue, concerns the different versions of SSRS. Our production database server is a SQL Server 2005 Standard Edition. We've got, on...

tom.wauters (3/30/2012)

---

You can access any database schema from within SSRS.

My first thoughts for your problem:

1. Make sure that the person who develops the report in SSRS is connecting with the...

I just...

Gail and Lynn, thank you both very much for your help. Using your advise I've come up with a couple of simpler maintenance plans (no shrinking of any databases),...

anthony.green (3/28/2012)

---

In terms of what Owner SSRS runs under what do you mean? It runs under what ever account you have specified in the data source to connect to...

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,...