Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003

    Question Unanswered: Recover a database from MDF and LDF

    If my SQL instance is not operational anymore because I lost the login credentials, Can I re-install SQL and recover the database from the MDF and LDF files?

  2. #2
    Join Date
    Aug 2002
    How about SA Login details, if you know the password or any account with SYSADMIN privileges you can connect to the server.

    Even to carry on detaching and attaching you should require SA or sysadmin login, without proper detaching of DB you cannot attach.

    Refer to Books online for SP_ATTACH_DB & SP_DETACH_DB for more information.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

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