Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 rename a Logical log file

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-11-12 : 07:41:40
How do I rename the logical filename just for log file?

instead file_1.LDF i want file_Log.LDF

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-11-12 : 07:44:39
Read about ALTER DATABASE in SQL Server help file

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

ranganath
Posting Yak Master

209 Posts

Posted - 2009-11-12 : 23:17:58
http://msdn.microsoft.com/en-us/library/bb522469.aspx
Go to Top of Page
   

- Advertisement -