FIX: Cannot restart SQL Server 2016 after you use ALTER DATABASE ADD FILE or ADD LOG command to add files with the same logical name

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

Symptoms


Assume that you run the ALTER DATABASE ADD FILE or ADD LOG command to add multiple files to a database, and accidentally you supply the same logical name to more than one file (for example, by the means of copy/paste). In this situation, you may notice that the SQL Server cannot restart after startup. Additionally, you may receive some error messages that resemble the following:

Date/Time spid6s      Starting up database DatabaseName.
Date/Time spid6s      Error: 1828, Severity: 16, State: 1.
Date/Time spid6s      The logical file name FileName is already in use. Choose a different name.
Date/Time spid6s      SQL Server shutdown has been initiated
Date/Time spid6s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

Resolution


Service pack information for SQL Server 2016

This issue is fixed in the following service pack for SQL Server: 

       Service Pack 2 for SQL Server 2016

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.