Connect to SQL server through the Management Console.Under Startup Parameters you will be adding the following parameters to the beginning of the string: -m -c -T3608 Right click on SQL Server and choose Properties.Click -> START -> Microsoft SQL Server 2005 -> Configuration Tools – > SQL Server Configuration Manager.However if you are like me and didn’t do this, these steps should get everything back on track. I would strongly suggest that you don’t be an idiot like me and make sure that you backup your msdb database. Figure that this is a small price to pay because let’s face it, you got to have backups. I will warn you that by doing these steps, you will lose all you Maintenance Plans that you had and you will have to recreate them. The following are the steps that I took to get everything back up and running. This was due to the fact that the MSDB database has been corrupted.
Seems that because of some diskspace issures we had in April, my MSSQL configure got hosed and the server hasn’t been able to perform any backups nor has the sql server agent been running.
Again I spent a gorgeous day in front of the computer trying to solve a major problem.
0 kommentar(er)
