How to consolidate physical files and rename the logical file name in SQL Server 2000 and in SQL Ser

IMPORTANT After you add or delete files, create a database backup immediately. You must create a full database backup before you create a transaction log backup. Rename Logical File Name To modify the logical name of a data file or a log file, specify the

support.microsoft.com