|
|
Posted by Hallgeir on 10/01/34 11:21
Thank you Erland! Your answer should help me a a great deal.
Regards Hallgeir.
"Erland Sommarskog" <esquel@sommarskog.se> skrev i melding
news:Xns9694718E16823Yazorman@127.0.0.1...
> Hallgeir (hallremovegeir@unitechsys.no) writes:
>> My msdb database is marked as suspect. This means that my maintenance
>> plan doesn't work. I'm a novice when it comes to sql server so now I'm
>> wondering if anyone could give a hint on how to fix the suspect msdb
>> database? Does this database contain any vital information? What could
>> be the reason that this database become suspect?
>
> If you look up "suspect" in the Index of Books Online, you will find a
> troubleshooting article that says that the cause is lack of disk space.
> However, I believe that there are possible reasons as well - read:
> corruption.
>
> This topic also discusses you can address the problem, if the issue is
> indeed lack of diskspace.
>
> If the problem is corruption, restoring a backup may be a safer way to go.
>
> The msdb database is the database that holds information about SQL Server
> Agent jobs (of which the maintenance plan is one). It also have tables for
> backup history of databases. It's definitely a database that you should
> back up regularly. It's usually not that big, so it sounds a little funny
> that you would run of disk space because of it.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|