Viewing 15 posts - 1,621 through 1,635 (of 1,949 total)
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...
April 4, 2012 at 11:57 am
Lynn Pettis (4/2/2012)
Rod at work (4/2/2012)
tom.wauters (4/2/2012)
First of all, your databases will be in the newer environment, which has lots of...
April 2, 2012 at 11:19 am
tom.wauters (4/2/2012)
First of all, your databases will be in the newer environment, which has lots of improvements compared to SQL Server...
April 2, 2012 at 10:39 am
SQLRNNR (3/30/2012)
Rod at work (3/30/2012)
March 30, 2012 at 10:30 am
Jason, when you said:
This is behavior that I have seen occasionally. It is fixed with 2008.
Did you mean SQL Server 2008 (or SQL Server 2008 R2), or did you mean...
March 30, 2012 at 10:28 am
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...
March 30, 2012 at 9:18 am
tom.wauters (3/30/2012)
My first thoughts for your problem:
1. Make sure that the person who develops the report in SSRS is connecting with the...
March 30, 2012 at 9:15 am
SQLRNNR (3/29/2012)
We have multiple schemas and use ssrs to access procs in those different schemas.If you log on as the particular user, can you see the proc in question?
I just...
March 30, 2012 at 8:40 am
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),...
March 28, 2012 at 9:58 am
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...
March 28, 2012 at 8:08 am
GilaMonster (3/27/2012)
Re log backups...
March 27, 2012 at 2:59 pm
Lynn Pettis (3/27/2012)
Here is a link that covers what I was talking about regarding the master database: http://msdn.microsoft.com/en-us/library/ms191488.aspx.
Thank you, Lynn, I'm reading it now.
March 27, 2012 at 2:57 pm
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,...
March 27, 2012 at 2:23 pm
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...
March 27, 2012 at 1:09 pm
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...
March 27, 2012 at 12:56 pm
Viewing 15 posts - 1,621 through 1,635 (of 1,949 total)