Hi All,

I would like to be able to change the physical name of the transaction
log in my SQL 2000 database. For instance, I would like to be able to
change D:\Program Files\Microsoft SQL Server\MSSQL\Data\filename1.ldf
TO D:\Program Files\Microsoft SQL Server\MSSQL\Data\filename2.ldf . Is
that possible and will there be any problems with me doing that?
Thanks.

Did you look in Books Online? That's where I look for the syntax of how to
do something, if I don't know it off the top of my head.

ALTER DATABASE database_name
MODIFY FILE
(
NAME = log_file_name,
FILENAME = 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\filename2.ldf'
);

You will need to cycle SQL Server before the move is complete.

I am not sure what you would gain out of this specific move, however.



"Balldigy" <balldigy@gmail.com> wrote in message
news:583608eb-b981-4658-b1ef-ceda07f21174@u12g2000prd.googlegroups.com...
> Hi All,
>
> I would like to be able to change the physical name of the transaction
> log in my SQL 2000 database. For instance, I would like to be able to
> change D:\Program Files\Microsoft SQL Server\MSSQL\Data\filename1.ldf
> TO D:\Program Files\Microsoft SQL Server\MSSQL\Data\filename2.ldf . Is
> that possible and will there be any problems with me doing that?
> Thanks.

Just for the same of completeness, one have to actually move the physical file as well, as outlined
in:
ms-://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ad9a4e92-13fb-457d-996a-66ffc2d55b79.htm

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


"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:OYnTXlqtIHA.3968@TK2MSFTNGP04.phx.gbl...
> Did you look in Books Online? That's where I look for the syntax of how to do something, if I
> don't know it off the top of my head.
>
> ALTER DATABASE database_name
> MODIFY FILE
> (
> NAME = log_file_name,
> FILENAME = 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\filename2.ldf'
> );
>
> You will need to cycle SQL Server before the move is complete.
>
> I am not sure what you would gain out of this specific move, however.
>
>
>
> "Balldigy" <balldigy@gmail.com> wrote in message
> news:583608eb-b981-4658-b1ef-ceda07f21174@u12g2000prd.googlegroups.com...
>> Hi All,
>>
>> I would like to be able to change the physical name of the transaction
>> log in my SQL 2000 database. For instance, I would like to be able to
>> change D:\Program Files\Microsoft SQL Server\MSSQL\Data\filename1.ldf
>> TO D:\Program Files\Microsoft SQL Server\MSSQL\Data\filename2.ldf . Is
>> that possible and will there be any problems with me doing that?
>> Thanks.
>
>