Hello:

Can you simply use the following scripting to move the log files for
Reporting Services and the distmdl.ldf file to another drive (similar to the
scripts for the tempdb database)?:
USE master;
GO
ALTER DATABASE 'name of database'
MODIFY FILE (NAME = tempdev, FILENAME = 'E:\SQLData\tempdb.mdf');
GO
ALTER DATABASE 'name of database'
MODIFY FILE (NAME = templog, FILENAME = 'F:\SQLLog\templog.ldf');
GO

Thanks!

SQL Programmer (it's just a name)

This commands doesn't actually move any files. Check out the Books Online section about moving
databases and you will find that you also need to do the moving of the files (yourself), including
some db offline stuff while doing that (from memory).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"SQL Programmer" <SQLProgrammer@discussions.microsoft.com> wrote in message
news:4F066B6D-3362-440E-A7FC-BA2D4F0F8365@microsoft.com...
> Hello:
>
> Can you simply use the following scripting to move the log files for
> Reporting Services and the distmdl.ldf file to another drive (similar to the
> scripts for the tempdb database)?:
> USE master;
> GO
> ALTER DATABASE 'name of database'
> MODIFY FILE (NAME = tempdev, FILENAME = 'E:\SQLData\tempdb.mdf');
> GO
> ALTER DATABASE 'name of database'
> MODIFY FILE (NAME = templog, FILENAME = 'F:\SQLLog\templog.ldf');
> GO
>
> Thanks!
>
> SQL Programmer (it's just a name)