CREATE DATABASE failed. Some file names listed could not be created

Locked CREATE DATABASE failed. Some file names listed could not be created

  • 2012년 8월 16일 목요일 오전 5:36
     
     

    I am getting below error on a machine while installing my application. Application is creating a sql database from code in starting

    CreateDataBase Stack Trace : System.Data.SqlClient.SqlException:CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
    MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at DashBoard.DBSQLScripts.CreateDatabase(String strDBName, String strIPAddress, String strInstanceName, String strCompanyName, String strTargetPath, String strCono, String strDbPath, String strSQLlogin, String strSQLPwd, String strODBName, String strCreateDb)

    Let me know if it is not right place for this question.

    Thanks


    Want to add MVP with my name.

모든 응답

  • 2012년 8월 16일 목요일 오전 7:47
     
     
    It was clearly mensioned There is not enough space on the disk. Please clear some file and give the enough space to install.

    With Thanks and Regards
    Sambath Raj.C
    click "Proposed As Answer by" if this post solves your problem or "Vote As Helpful" if a post has been useful to you
    Happy Programming!

  • 2012년 8월 16일 목요일 오전 8:39
     
     
    Actually there is around 30 GB in my C drive. and when I restore database it doesn't take more than 1 GB.

    Want to add MVP with my name.

  • 2012년 8월 16일 목요일 오후 12:20
     
     답변됨
    Is your machine also the database server? If you are creating a database on a different server maybe the server is out of disk space.

    Bob - www.crowcoder.com

    • 답변으로 표시됨 bahushekh 2012년 8월 23일 목요일 오전 6:27
    •  
  • 2012년 8월 16일 목요일 오후 8:45
     
     

    Hi,

    Or in addition to Molku if you have multiple drives, could it be that files are created on another drive than C: ? For now I would trust the error message.


    Please always mark whatever response solved your issue so that the thread is properly marked as "Answered".