Use the following code snippits to identify and rename logical file names in Microsoft SQL Server.
Determine the logical file names
USE [database_name] GO sp_helpfile GO
Rename logical file names
USE master GO ALTER DATABASE database_name MODIFY FILE ( NAME = 'current_logical_name', NEWNAME = 'new_logical_name') GO
SQL 2008 returns the following confirmation:
The file name 'new_logical_name' has been set.