I know it's been a while since I last responded to this tread, but it's becoming important again. I think what happened was the former DBA, when he set...

Lynn Pettis (4/2/2012)

---

Rod at work (4/2/2012)

---

tom.wauters (4/2/2012)

---

I would suggest to migrate to SQL Server 2008 R2.

First of all, your databases will be in the newer environment, which has lots of...

tom.wauters (4/2/2012)

---

I would suggest to migrate to SQL Server 2008 R2.

First of all, your databases will be in the newer environment, which has lots of improvements compared to SQL Server...

SQLRNNR (3/30/2012)

---

Rod at work (3/30/2012)

---

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

Jason, when you said:

Did you mean SQL Server 2008 (or SQL Server 2008 R2), or did you mean...

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