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.