Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005
As a DBA you might have come across this situation where you have forgotten the sa password for SQL Server - so what can you do?
If you are experienced with such situation then definetly you might have an alternative solution to keep the passwords in safe. The easiest way around this is to logon to the actual SQL Server NT machine itself as administrator, if you haven't removed the builtin\administrator group from SQL Server. If you're in mixed-mode and you know the NT userid of someone with sa rights, then get their password reset and logon/connect as them. I don't see any reason for not having any additional login with SYSADMIN privileges.
Coming to SQL Server 2005 there is much information & steps to take care from RaulGarcia's blog post. Better never than later, ensure you adhere to security policies within your environment.
