Monday, March 26, 2012

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

No comments:

Post a Comment