Unable to attach a database in SQL Server 2000

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • prajeeshv
    New Member
    • Jan 2007
    • 1
    #1

    Unable to attach a database in SQL Server 2000

    Hi Everyone,

    Have a nice day... I've a problem in SQL Server...

    I've detached my database from server. But I didn't remember the location of its .mdf (database) file. Now I'm unable to attach the database. Is there any way to locate the mdf file for a detached database, so I can attach it again...
    Any help on this will be appreciated...

    Thanks in Advance...

    Praji
    Tags: None
    • hariharanmca
      Top Contributor
      • Dec 2006
      • 1977
      #2
      Originally posted by prajeeshv
      Hi Everyone,

      Have a nice day... I've a problem in SQL Server...

      I've detached my database from server. But I didn't remember the location of its .mdf (database) file. Now I'm unable to attach the database. Is there any way to locate the mdf file for a detached database, so I can attach it again...
      Any help on this will be appreciated...

      Thanks in Advance...

      Praji

      Yes you can

        Comment

        • abhishek8236
          New Member
          • Dec 2006
          • 2
          #3
          So have u got the solution.. if no then do some R&D create a fake database and see the path of the database where is it going to create the new one, so the path will be same unless you have changed it during the creation. But if you have DROP the database then it cant be reattached. If you had created the database earlier using T-SQL, the path will be still same unless you had changed the Primary file location.

            Comment

            Previous template Next
            Working...