You must Sign In to post a response.
  • Category: Complaints

    Atach database error

    Error attaching database. System.Data.SqlClient.SqlException (0x80131904): Could not open new database 'ahmedsaltoh_ahmedsaltoh_FreightCargoService0408'. CREATE DATABASE is aborted. File activation failure. The physical file name "F:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\ahmedsaltoh_FreightCargoService0408_log.LDF" may be incorrect. The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure. 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() 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 AspSpiderMonitor.HostManager.AttachDatabase(String userId, String databaseName, String dataFile, String NetworkPath, String LocalPath, eUserType UserType)
  • #6988
    That's could happen because you attached SQL Server log file *.ldf (it's no need to upload and attach) just *.dbf file must be uploaded and attached.

  • Sign In to post your comments