And Ninja's_RGR'us, could you tell me a little bit what problem you have when you applying service pack to SSRS?

I never have an experience of applying sp to only reporting...

Thanks, but by looking at Ninja's_RGR'us's post above, he said:

" The one hang up we ran into with SSRS was getting the SP to apply to the SSRS instance. If...

Thank you very much.

This looks very helpful.

But i have a question about this, so later if I install SSRS, since sp2(I will install sp3, I think this doesn't matter) is...

Can you give a little more detail by what you mean : "The one hang up we ran into with SSRS was getting the SP to apply to the SSRS...

deleted

Thanks, is that same as P(physical) to V(virtual)?

Thank you! that's helpful.

Sorry, what does cold clone mean?

The current production server is a physical server, the new one we are going to setup is a virtual one.

Can we still do the...

Thank you all.

Above question is all about my new server set up.

By the way for my current existing physical server, it also has 8 gb ram, but I can see...

Our network guy says the memory is not correct if I use default one.

So the default is (in MB) 2147483647, is this PB already? How come it is so huge...

Thank you, that's what I think too.

I will do the restore for user databases, then script out the logins and jobs.

The other difference for both the server, is the old...

Thanks

Thank you, this is very helpful and clear instructions.

I will give a try.

Thank you, that's helpful.

But I don't have any ssis packages on the server, but I do have some maintainance plan and some application jobs in sql server jobs.

I see an...

We will restore sql 2005 to another new sql 2005 server.

We plan to name the new computer something else first, then after restore, turn off old server, and rename the...