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?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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment