June 29, 2009 at 4:13 pm
Hi Folks
I have got SQLServer 2005 Developer Installed with SP2
and I now see a database called ReportServerTempDB on my C Drive
I plan to move all my databases off the C Drive and I have plan, thanks to everyone, to move TEMPDB to its own drive.
My question is, should the ReportServerTempDB database move to the same drive as TEMPDB or should it be moved to where my other databases will move to ?
Thanks
Jim
June 29, 2009 at 4:38 pm
No because SSRS and SSIS are not configurable components which means you leave both in C drive because both uses operating system resources. You should also know that you need to backup both ReportServerDb and ReportServerTmpDb because both are needed to move SSRS to a new server.
Kind regards,
Gift Peddie
June 29, 2009 at 10:12 pm
The location of the files for each database is transparent to the application using them - this includes reporting services. If you are wishing to keep using the same server for your ReportServer and ReportServerTempdb databases, then you can choose whatever drive you wish on the database server for the files required for these databases.
I would not put ReportServerTempDB on the same drive as TEMPDB. I would treat it the same as any other user database and, subject to performance, put it in the same location as the other user database files.
If you are moving to another database server, you will have issues with encrypted content. Reporting Services encrypts items such as credentials for data sources using the server name. So if the server name changes, the encrypted content is not accessible. Have a look in Books Online for information about moving to another server.
And finally, FYI : SSIS is configurable. There is an XML file that contains the configuration information e.g the sql server instance name used for storing packages. Unfortunately, I can't remember the name and I am working at customer where I don't have privilege to look it up. However, the file is in "C:\program files\Microsoft SQL Server".
June 30, 2009 at 7:41 am
And finally, FYI : SSIS is configurable. There is an XML file that contains the configuration information e.g the sql server instance name used for storing packages. Unfortunately, I can't remember the name and I am working at customer where I don't have privilege to look it up. However, the file is in "C:\program files\Microsoft SQL Server".
I will say the part of SSIS I use which is for ETL is not configurable and what is configurable is SSIS comes with a foot note.
http://msdn.microsoft.com/en-us/library/ms143547(SQL.90).aspx
Kind regards,
Gift Peddie
June 30, 2009 at 9:41 am
Thanks Gift Peddie
appreciate the assist
Jim
June 30, 2009 at 9:42 am
Thanks HappyCat59
appreciate the info on this one
Jim
July 2, 2009 at 7:19 am
Mmm, I think Gift Peddie needs to do a little more research. SSIS packages are easily configured. Most properties that you can set using Visual Studio/BIDS can also be configured at runtime. To tell you the truth, the options and their flexibility can be a little daunting
Try searching for "SSIS COnfiguration" with your favourite search engine or in Books Online. You will get a huge number of web sites with stacks of information on how to configure SSIS packages e.g. http://msdn.microsoft.com/en-us/library/ms141682.aspx
July 2, 2009 at 7:34 am
SQL Server Integration Services component DLL's for the Data Transformation Run-time engine, the Data Transformation Pipeline engine, and the dtexec command prompt utility
Program Files\Microsoft SQL Server\90\DTS\Binn
Fixed path
We are not talking about the same thing you are talking about packages which everyone knows can be configured many ways, I am talking about SSIS runtime installation which is not configurable because it must be installed with a fixed path. Now I am not saying people don't move it but when moved some Agent dependent executions fail.
Kind regards,
Gift Peddie
July 2, 2009 at 2:29 pm
So Folks
bottome line...
should the reportserver database and the reportservertempdb databases stay on the c drive where they were installed or can they be moved ?
Thanks
jim
July 2, 2009 at 2:32 pm
JC (7/2/2009)
So Folksbottome line...
should the reportserver database and the reportservertempdb databases stay on the c drive where they were installed or can they be moved ?
Thanks
jim
I would not move them because both comes with Fixed Path installation requirements.
Kind regards,
Gift Peddie
July 2, 2009 at 10:09 pm
Again, Gift Peddie needs to understand the technology before answering.
Reporting Services is not aware of the location of the files used for any database including ReportServer and ReportServerTEMPDB. All it knows is that the databases are managed by a particular instance of SQL Server. They do not even need to be on the same Windows Server as the installation of Reporting Services.
So, if you have a need to move the mdf and ldf files on the same server, you can do this without any problems from Reporting Services. You can detach/attach or backup/restore the databases to acheive this.
July 3, 2009 at 7:43 am
Reporting Services is not aware of the location of the files used for any database including ReportServer and ReportServerTEMPDB. All it knows is that the databases are managed by a particular instance of SQL Server. They do not even need to be on the same Windows Server as the installation of Reporting Services.
Reporting Services report server
\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer\Bin
Configurable
Reporting Services report manager
\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportManager\Bin
Fixed path
Again I understand what I am talking about yes SSRS databases can be located in remote server but in that remote server Report Server Manager installation path is fixed. This not to say people are not moving these components but moving these components comes with issues that is it does not work all the time. It is in the BOL ReportServerDB and ReportServerTempDB are not for general use but I have talked to users creating reports to run from these databases. Implementation related issues is what keeps Microsoft support busy.
Kind regards,
Gift Peddie
July 5, 2009 at 12:37 pm
I don't have mine on the C: drive but a dedictaed drive for ReportServer and ReportServerTempDB. Also, I've done quote a few backups and restores to move servers around and only the ReportServer needs to be moved, probived where ever you're moving it to already has an SSRS installation.
July 6, 2009 at 2:18 am
@jc-2: There should be no problems moving those 2 DBs to whichever disks you want. Most of our production servers have these co-located with the rest of the user database files and log files on seperate disks, respectively. ReportServerTempDBis not really like TempDB itself - it stores session and execution data from the RS instance rather than materialised result sets, etc. like the real TempDB. Treat it like any other user database - put it on its own spindles if you have the disks to spare 😉
Regards,
Jacob
July 6, 2009 at 9:33 am
Hi Jacob
thanks for your input
Jim
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply