Database error

Last post 08-20-2009 10:54 PM by chetan.sarode. 5 replies.

Sort Posts:

  • Database error

    11-03-2005, 11:51 AM
    • Member
      5 point Member
    • castlerigg
    • Member since 11-03-2005, 4:46 PM
    • Posts 1
    Hi I just downloaded and installed the TimeTracker application. I get the following error when trying to create a new user:

    "Could not open new database 'C:\SOURCE .NET\TIMETRACKER\APP_DATA\TIMETRACKER.MDF'. CREATE DATABASE is aborted.
    An attempt to attach an auto-named database for file C:\source .NET\TimeTracker\App_Data\TimeTracker.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
    File activation failure. The physical file name "C:\source .NET\TimeTracker\App_Data\TimeTracker_log.ldf" may be incorrect.
    The log cannot be rebuilt when the primary file is read-only."

    Any idea what this means? I'm using the .NET 2.0 final release version.

    Thanks in advance.

  • Re: Database error

    06-03-2009, 10:50 AM
    • Member
      2 point Member
    • prasoon
    • Member since 06-03-2009, 2:47 PM
    • Posts 1

     Hi

       Just look into your Data folder ,the Log with the name might not be existing.

      The LDF fiel must be there with some other name like databasename_1 etc.

      Just rename the LDF file to database_log. and it should work.

    Thanks and Regards 

    Prasoon.

  • Re: Database error

    06-03-2009, 10:56 PM

    The error message indicates that either the database file you are trying to attached has already been attached in sql express or there is data corruption in your database file(.mdf file) , thus the db file could not be attached. I would suggest you connect to your sql express server through management studio to make a verification (Note here that since Sql Express use customer instance, in management studio, you must login using the same account as the one you used in your application). If that db file has been attached, detach it and take another try.

    If there is no such file attached already in your sql express, I would suggest you first attach that mdf file to your database. If you still get this error, it means that the mdf file is data corrupted (information in ldf file and mdf file does not match) and cannot be used anymore---You need to restore it then.

     Hope my suggestion helps

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
  • Re: Database error

    06-14-2009, 10:57 PM

    Can you please update the status

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
  • Re: Database error

    06-15-2009, 11:03 PM

    If you solved the error then please mark the answer for the post that helps you

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
  • Re: Database error

    08-20-2009, 10:54 PM

     Are you able to create a new user now

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
Page 1 of 1 (6 items)