help me......Error attaching database in ASP.NET

Advertise with us

Control Panel Forum Hosting Help ASP.NET 4.5 & SQL 2012 Hosting Resources Notice

Home » Questions & Answers » help me......Error attaching database

help me......Error attaching database

06 Jun, 12

Author: ArieYaDosi
Poliban

There was an error when I do attach a database, I am confused Diman my fault, please help:

Error attaching database. System.Data.SqlClient.SqlException: Could not open new database 'dosiarie91_ServiceHondaDosi'. CREATE DATABASE is aborted. File activation failure. The physical file name D:\dokumen semester 4\Sistem Basis Data\sql server 2008\ServiceHondaDosi_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(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 SpiderWatch.HostManager.AttachDatabase(String userId, String databaseName, String dataFile, String NetworkPath, String LocalPath, eUserType UserType)
Error opening attached database. Cannot open database dosiarie91_ServiceHondaDosi requested by the login. The login failed. Login failed for user 'DOTNETSPIDER1\dotnetspider'.

Answers .............

Author: Zeb Simpson

Posted Date: 06 Jun, 12

When you are adding the DB files, only save the .mdf file not the .ldf. Make sure to delete it before trying to attach it and it will create one for you.

You must login to post answer for this question.

Total members: 250957
Average new registrations per day (in last 7 days): 8

New Registration: Open

Register Now

Talk to Webmaster
Tony John

Facebook
Google+
Twitter