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.
精彩评论