Moving the Reprot Server log files in 2005

I have just setup a SQL Server 2005 instance and am seperating the log files
on a seperate drive. Can the ReportServer and ReportServerTempDB log files be
moved just like any user database or are there special instructions for
moving the log file of these two databases? I have searched the MS Knowledge
Base and could only find an article about moving the entire RS databases to a
new server.
Any help would be appreciated.
Hi
"MACason" wrote:

> I have just setup a SQL Server 2005 instance and am seperating the log files
> on a seperate drive. Can the ReportServer and ReportServerTempDB log files be
> moved just like any user database or are there special instructions for
> moving the log file of these two databases? I have searched the MS Knowledge
> Base and could only find an article about moving the entire RS databases to a
> new server.
> Any help would be appreciated.
You should be able to move the location of the database log files like any
other database. You would need to stop Reporting Services before doing so.
John

Moving the Reprot Server log files in 2005

I have just setup a SQL Server 2005 instance and am seperating the log files
on a seperate drive. Can the ReportServer and ReportServerTempDB log files b
e
moved just like any user database or are there special instructions for
moving the log file of these two databases? I have searched the MS Knowledge
Base and could only find an article about moving the entire RS databases to
a
new server.
Any help would be appreciated.Hi
"MACason" wrote:

> I have just setup a SQL Server 2005 instance and am seperating the log fil
es
> on a seperate drive. Can the ReportServer and ReportServerTempDB log files
be
> moved just like any user database or are there special instructions for
> moving the log file of these two databases? I have searched the MS Knowled
ge
> Base and could only find an article about moving the entire RS databases t
o a
> new server.
> Any help would be appreciated.
You should be able to move the location of the database log files like any
other database. You would need to stop Reporting Services before doing so.
John

Moving ReportServer and ReportServerTempDB to a different drive.

I need to move these databases from the C to the E driver on the existing server. I found instructions on how to move to a different server but I could not find specific instructions on moving these databases on what I need to dor. Has anyone been successfully in moving these databases to a different drive? If so, I would be grateful in you sharing your knowledge.

Thanks.

While these databases contain metadata for SSRS, they are not particularly special otherwise, just detach/re-attach them as you would any other database :)

If you're unclear on how to attach/detach, take a look at the sp_attach_db and sp_detach_db sprocs in books online (FYI, SSRS will need to be shut down while you do this or you won't be able to detach in the first place since it will have open connections)

Hope this helps!

|||I am familiar with the attach and detach stored procedures, so I will try this out on one of our virtual servers. Thanks a lot.

Moving Reporting Service Database

Hi, I need to move the both Reporting Service Databases "ReportServer" and
"ReportServerTempDB" to another SQL Server, only the both DB are moved, the
Server with installed RServices remains the same. Is there some dokument
about? Thnakssomething like this?
http://support.microsoft.com/kb/842425
"MV" <MV@.MV.MV> wrote in message
news:OeURCYVRHHA.3316@.TK2MSFTNGP02.phx.gbl...
> Hi, I need to move the both Reporting Service Databases "ReportServer" and
> "ReportServerTempDB" to another SQL Server, only the both DB are moved,
> the Server with installed RServices remains the same. Is there some
> dokument about? Thnaks
>|||Thank you a lot ! I needed exactly this, but how can I find out the password
from the user DOMAIN\MACHINE$ '
this is the user that have RSExecRole on the Database, this user must I give
as parameter to the RSConfig command line tool
Thanks
"Immy" <therealasianbabe@.hotmail.com> schrieb im Newsbeitrag
news:exaCzfVRHHA.3996@.TK2MSFTNGP04.phx.gbl...
> something like this?
> http://support.microsoft.com/kb/842425
> "MV" <MV@.MV.MV> wrote in message
> news:OeURCYVRHHA.3316@.TK2MSFTNGP02.phx.gbl...
>> Hi, I need to move the both Reporting Service Databases "ReportServer"
>> and "ReportServerTempDB" to another SQL Server, only the both DB are
>> moved, the Server with installed RServices remains the same. Is there
>> some dokument about? Thnaks
>|||You will need to either use a domain account or sql account.
If you use a domain account, you need to see your system administrator who
should be able to give you the password.
Sorry - no trick to obtain the password (legally that I know of anyway) :-)
"MV" <MV@.MV.MV> wrote in message
news:Oo81aVeRHHA.2076@.TK2MSFTNGP05.phx.gbl...
> Thank you a lot ! I needed exactly this, but how can I find out the
> password from the user DOMAIN\MACHINE$ '
> this is the user that have RSExecRole on the Database, this user must I
> give as parameter to the RSConfig command line tool
> Thanks
>
> "Immy" <therealasianbabe@.hotmail.com> schrieb im Newsbeitrag
> news:exaCzfVRHHA.3996@.TK2MSFTNGP04.phx.gbl...
>> something like this?
>> http://support.microsoft.com/kb/842425
>> "MV" <MV@.MV.MV> wrote in message
>> news:OeURCYVRHHA.3316@.TK2MSFTNGP02.phx.gbl...
>> Hi, I need to move the both Reporting Service Databases "ReportServer"
>> and "ReportServerTempDB" to another SQL Server, only the both DB are
>> moved, the Server with installed RServices remains the same. Is there
>> some dokument about? Thnaks
>>
>