Cannot login to server - Error 900007501 and SQLManagement Studio says "It has been marked suspect by recovery"

Follow

Description

When you try to login to the DyKnow server, it will give you a 900007501 error. Additionally, when you try to log into SQL Management Studio, it says it cannot connect because "It has been marked suspect by recovery."

Solution

If  the DyKnow database has not been corrupted, you will need to create a new msdb database.

1. http://technet.microsoft.com/en-us/library/dd207003.aspx#CreateMSDB
2. Recreate Recurring Processing Job (from Script)
3. Recreate Daily Processing Job (from Script)
4. Recreate Backup Job (from Script or Manual)

 

Have more questions? Submit a request

Comments

Powered by Zendesk