-
Title
Error: CREATE DATABASE failed. Some file names listed could not be created. Check related errors. -
Description
LiteSpeed Error:
CREATE DATABASE failed. Some file names listed could not be created. Check related errors. during install or upgradeMicrosoft SQL Server 2005 error:
Create failed for Database 'LiteSpeedLocal'. (Microsoft.SqlServer.Smo)
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\LiteSpeedLocal.mdf' because it already exists. Change the file path or the file name, and retry the operation. (Microsoft SQL Server, Error: 1802) -
Cause
The LiteSpeedLocal.mdf or LiteSpeedLocal.ldf file(s) already exists in the default location. The LiteSpeedLocal or LiteSpeedCentral may have been renamed after their creation, but the mdf and ldf files have the original names.
-
Resolution
1. To determine which file is causing the error, in Enterprise Console or SSMS, create a LiteSpeedLocal and/or LiteSpeedCentral database, the resulting Microsoft error message lists the specific file that is the problem.
2. Rename the LiteSpeedLocal and/or LiteSpeedCentral mdf and ldf files. Restart the Instance Configuration or upgrade process. -
Additional Information
An enhancement request has been submitted for additional details to be displayed onscreen for the LiteSpeed error.