开发者

Is there an application that works as DBCC wizard?

DBCC (DB Consistency Check) commands are powerful tools but they don,t have a graphical user interface. now 开发者_StackOverflowIs there a application that works like DBCC wizard?


Some of the advanced options for DBCC (such as trying to repair corruption whilst allowing dataloss) are probably best left for experienced DBAs - so perhaps that is the reason why there is no GUI.

You can, of course, do a standard checkDB via a maintenance plan, which has a wizard. Easy enough, and a best practice to run a checkDB at least once a week.

Slightly off topic, but I did see a Microsoft Connect ticket to include the "last known good date" in the system view sys.databases in a future version of SQL Server.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜