sql database

Last post 04-23-2009 11:22 PM by chetan.sarode. 18 replies.

Sort Posts:

  • sql database

    01-05-2009, 10:13 AM
    • Member
      6 point Member
    • arkiboys
    • Member since 07-01-2008, 7:38 AM
    • Posts 43

    Hi,
    I can now add projects, assign users, etc...
    I am now investigating the database side of this project. It seems the data is being save in sql server .mdf file
    There is now a TimeTracker.mdf in the data folder of sql server but I can NOT create this database in the object explorer using attach database.

    When doing this in sql 2005 by right click, new database; this is the error I get:
    create database failed. some file names listed could not be created. Check related errors. Can not create file 'c:\program files\...\TimeTracker.mdf' because it already exists. change the filepath or the file name, and retry the operation.
    Note that there is a .mdf file in the above path already and I would

    like to use that as the database.
    So I try to attached this .mdf file, and I get this error when attaching it:
    create file encouontered operating system error 32(error not found) while attempting to open the physical file 'c:\program files\TimeTracker.mdf' (Error 5123)

    Any suggestions please?

  • Re: sql database

    01-05-2009, 12:57 PM
    • Contributor
      2,309 point Contributor
    • Lolli
    • Member since 10-17-2006, 10:15 PM
    • Huntington Beach, CA
    • Posts 455

     You need to attach the database in SQL Server Management Studio and not create it.

    Lolli

    Don't forget to click "Mark as Answer" on the post that helped you. This credits that member, earns you a point and marks your thread as Resolved so we will all know you have been helped.
  • Re: sql database

    01-07-2009, 10:25 PM

    Time Tracker use the TimeTracker.mdf' under SQL Server Express,

    So you have to attach to Sql server Management studio.

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
  • Re: sql database

    01-09-2009, 2:53 AM
    • Member
      6 point Member
    • arkiboys
    • Member since 07-01-2008, 7:38 AM
    • Posts 43

    The system does not allow me to attached.

  • Re: sql database

    01-09-2009, 11:27 AM
    • Contributor
      2,309 point Contributor
    • Lolli
    • Member since 10-17-2006, 10:15 PM
    • Huntington Beach, CA
    • Posts 455

     Is this a local server?

    Lolli

    Don't forget to click "Mark as Answer" on the post that helped you. This credits that member, earns you a point and marks your thread as Resolved so we will all know you have been helped.
  • Re: sql database

    01-09-2009, 5:31 PM
    • Member
      6 point Member
    • arkiboys
    • Member since 07-01-2008, 7:38 AM
    • Posts 43

    Yes it is.

  • Re: sql database

    01-10-2009, 7:23 AM
    • Contributor
      5,210 point Contributor
    • RickNZ
    • Member since 01-01-2009, 3:43 AM
    • Nelson, New Zealand
    • Posts 862

    Check to make sure that the sqlservr.exe user has read and write access to the MDF file.  You can see who the user is with Task Manager.

  • Re: sql database

    01-10-2009, 5:18 PM
    • Member
      6 point Member
    • arkiboys
    • Member since 07-01-2008, 7:38 AM
    • Posts 43

    It shows Administrator who is me logged in to the machine.

  • Re: sql database

    01-12-2009, 10:24 PM

    Try to install VS 2005 SP1 and other other related updates

    May solve this one

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
  • Re: sql database

    01-23-2009, 2:09 AM
    • Member
      528 point Member
    • kathirvelmm
    • Member since 05-05-2008, 7:46 AM
    • Chennai-India
    • Posts 160
     
    1    EXEC sp_attach_db @dbname = 'PUBS', 
    2    
    3         @filename1 = '\Program Files\Microsoft SQL Server\MSSQL\Data\PUBS.mdf', 
    4         @filename2 = '\Program Files\Microsoft SQL Server\MSSQL\Data\PUBS_LOG.ldf'
    5    
    6    sp_detach_db [ @dbname = ] 'dbname' 
    7                 [ , [ @skipchecks = ] 'skipchecks' ] 
    8    
    
     

     

      Hope this helps run this with master
    Kathirvel
    Follow me here
    Please mark as Answer if this solves your problem, Let other users get benefited.


  • Re: sql database

    01-23-2009, 12:50 PM
    • Member
      148 point Member
    • KentWA
    • Member since 01-17-2003, 4:23 PM
    • Posts 35

    When you have the web site open in Visual Studio you can use the Database Explorer to examine the database. You should find it on the View menu of VS.

  • Re: sql database

    01-29-2009, 10:28 PM

    What is the status, Please update

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
  • Re: sql database

    02-04-2009, 10:25 PM

    Have solved your error

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
  • Re: sql database

    02-11-2009, 10:01 PM
    • Member
      8 point Member
    • xzf2001
    • Member since 02-12-2009, 2:48 AM
    • Posts 6

    if you start the vs,it may be use the database.you should to release it!

  • Re: sql database

    02-25-2009, 10:22 PM

    Any updates on this

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
Page 1 of 2 (19 items) 1 2 Next >