//

How to Recover Suspect MSDB Database in SQL Server? | SQL Server DBA

Why MSDB Database Goes Into Suspect Mode?There can be several reasons for a MS SQL Server to get in a suspect mode. These are:MSDB data file or MSDB log file have got corrupt or damaged.Unavailability or crashing of database filesSystem failure in which SQL Server is installedVirus intrusion in a SQL Server systemDevice having the SQL Server is going offlineLack of Disk space to store MSDB database.Improper shutdown can also cause the suspect mode of MSDB database.Consequences: You can get an error message as you start MS SQL Server Management Studio or while accessing the database from visual studio. It might be display, “MSDB was in suspect state (SQL Server Error 926)” and you need to repair or recover suspect MSDB database and following window can appear on your screen.

Источник: How to Recover Suspect MSDB Database in SQL Server? | SQL Server DBA

 

Ни дай Бог такое увидать конечно.. Нужно будет опробовать на полигоне.

Богатый опыт работы с Sybase Replication Server, Sybase ASE Server, MS SQL Server

Опубликовано в SQL, Серверы

Добавить комментарий

Ваш e-mail не будет опубликован. Обязательные поля помечены *

*