.mdf is not a primary database file

Discussion in 'Databases' started by balu_dotnet, Jan 22, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. balu_dotnet

    balu_dotnet

    Hi i am trying to attach my database (wtih .mdf & .ldf )in windows vista (SQL2005)
    i am getting this Error: .mdf is not a primary database file

    can any one help?
     
    balu_dotnet, Jan 22, 2009
    #1
  2. JorgeR

    JorgeR DiscountASP.NET Staff

    You can tried to add the file using the command sp_attach_single_file_db. It is possible that the database may have been corrupted when it was downloaded. In either case, try to restore it from a bak file


    junior

    DiscountASP.NET

    www.DiscountASP.NET
     
    JorgeR, Jan 22, 2009
    #2
  3. balu_dotnet

    balu_dotnet

    Thanks for Rply i tried with sp_attach_single_file_db, but it didn't work. may i i didn't good bkup. i will try again
     
    balu_dotnet, Jan 26, 2009
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page