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

    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
    Location
    Scotland
    Posts
    1,578
    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
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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