Simple

In my case, I am taking a fullbackup at 8pm. I don't have other backup plans(simple, bulk logged).This fullbackup will be done at about 9.30pm. Backups are taken everyday and...

Guys, I am replying the answer for my own question here. Hopefully someone else will get an opportunity learning from what I have done here. The problem was with the...

Thanks for your input.....

Actually, on the "buying" thing, I have also approached my company to do that, but unfortunately they have spent that budget into some other tool and that...

How do you know that it is the reporting services that is causing this?

Did you do any query at that time? If so, what did you query that made you...

I have faced this problem before and the solution was this.

Go to My Computer>C Drive>Program Files>MSSQL 2005>MSSQL3>Reporting Services>ReportServer>Web(XML Configuration File)

Compare yours with the one I have attached here.

Note that the...

Yes. It is. After changing that, I am now able to see my report manager.

Now, I am trying to follow what you have stated up above. I am currently fine....

Yes, and nobody answered me yesterday. So I decided to give more info. I have some helpful people answering me today though! (Why? do you want to answer this post?...

My question would be why do you use Union All 4 times after each lookup? Why don't you just use 1 Union All and try it.

Well, let me summarize your advise:

You are telling me that it MAY work faster if I copy the whole folder from my PC(DEVELOPMENT) to the remote server(QA) through "Copy and...

Well, actually it is a little bit more complicated than that. We are about to upgrade to 2005 BUT by uninstalling the 2000 in the same box using a detach/attach...

Thanks for your answer. Will this work out well( other than the outer joins issue)? Have you face any trouble after that? Like some jobs failing and all that?

Please guide...

Thanks on that........

Is there any specific percentage that I should apply to follow for the size?

Also, this machine is going to be active with Integration Services as well. Is there...

Okay. It works on all now. ( I swear it did not work the first time). I am still confused how it is working now OR why it did not...

First of all, you have to check if the Internet Information Services (IIS) is turned on or not? Then check your permission there by right clicking the Default Website and...