11-13-2017 02:26 AM - edited 11-13-2017 02:38 AM
Hello,
Backup Exec Database is giving error while trying to Rebuild Indices, Perform a Consistency Check, Compact etc.
The only option that works is repair database. Please see the screenshots below:
In SQL Server Management Studio
Msg 3857, Level 16, State 1, Line 2
The attribute (assembly_id=NULL) is required but is missing for row (object_id=786205951) in sys.assembly_modules.
Msg 3857, Level 16, State 1, Line 2
The attribute (assembly_id=NULL) is required but is missing for row (object_id=802206008) in sys.assembly_modules.
Msg 3853, Level 16, State 1, Line 2
Attribute (object_id=818206065) of row (object_id=818206065,parameter_id=0) in sys.parameters does not have a matching row (object_id=818206065) in sys.objects.
Msg 3853, Level 16, State 1, Line 2
Attribute (object_id=818206065) of row (object_id=818206065,parameter_id=1) in sys.parameters does not have a matching row (object_id=818206065) in sys.objects.
Msg 3853, Level 16, State 1, Line 2
Attribute (object_id=834206122) of row (object_id=834206122,parameter_id=1) in sys.parameters does not have a matching row (object_id=834206122) in sys.objects.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Any ideas how to solve the problem better with the Database? Maybe somehow to recreate it to solve the errors above?
Thank you
11-16-2017 05:07 AM
Normally BEutility.exe would fix issues with the BEDB, but in this case if it isn't, I'd recommend opening a support case directly with Veritas so that they can check it out for you.