Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    30

    Question Unanswered: the second problem

    After my SQL server accidentally crushed, I copied the databases to newly setuped server

    I have 2 databases :

    1) AAA..MDF
    AAA._DATA.mdf
    AAA._log.ldf

    2) BBB.ldf
    BBB.mdf

    After I moved them to /Data folder, only AAA was recognized. How I can install BBB ?

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: the second problem

    what exactly did u do?
    u need to attach these datafiles to create a database outof them.

  3. #3
    Join Date
    Jan 2004
    Posts
    30

    Re: the second problem

    Originally posted by harshal_in
    what exactly did u do?
    u need to attach these datafiles to create a database outof them.

    You mean that I have to create a new database and attack the files to this database ...

    How I can do that ?

  4. #4
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: the second problem

    Originally posted by The-Saint
    You mean that I have to create a new database and attack the files to this database ...

    How I can do that ?
    no need to create a new database
    what do u mean by copied the databases?
    If u have copied the .mdf files, then in the Enterprise manager, just right click the databases u'll find attach database click it and give it the path for the mdf file. it'll create that database for u.
    regards,
    Harshal.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •