The TempDB stores Session data, Cached reprots and execution data.  ReportServer database contains report definitions, schedules and other similar data.  These databases are designed to be used with Reporting Services...

Hiya,

I believe the official line is that system databases can not be restored to different versions of SQL Server:

https://msdn.microsoft.com/en-us/library/ms190190.aspx#Anchor_0

That being said, I can't think of a reason why...

Just thought I'd close this one off.

The in place upgrade went ahead this weekend just gone and it was a simple, albeit lengthy process. I decided to shut down...

Hi,

Yes, it's just a Standard to Enterprise edition change. The test I performed went very well so I'm reasonably confident that it will go smoothly but it's always...

Hi, thanks for your response.

Unfortunately it's not virtual. Would be nice to have that sort of safety net.

I think I'm going to have to just take the plunge here...

Hi,

Obviously each SQL Server could differ with regards to what is affected by the server's domain changing but here are a few things to look out for, particularly if the...

Okay, placing the file there does seem to have fixed that issue, thanks for the suggestion.

Hi opc.three and thanks for your reply.

The file won't exist at the point this package is ran. The job that will eventually invoke this package, deletes the old file...

Hi ALZDBA, thanks for your response.

I have taken a look at the mirroring state changes and I can follow the failover through its state changes. I was looking for...

This article offers up a couple of things to try. Port conflicts and Alternate Access Mappings via SharePoint.

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/299d17b5-5aed-463e-bb34-f53c5f93f6a2