My backup DBCC results indicate that there are three warnings found in the message file. I went back through and found that we received the following: [master]begin dbcc checkdb (master, no index); [master] end dbcc checkdb (master, no index). Three separate warnings like this were found. Exactly what does (master, no index) mean? Should I be concerned about this if the back has no errors detected and the backup was complete? Thanks for any input you can give me.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
3 Warnings were found in the message file
- Thread starter YSHAW
- Start date
Apparently you were using SQL Agent and backing up a SQL Server database. Are you sure they are WARNINGS and not just ALERTS? It appears that you selected the option to check the database after backup and you chose to 'exclude indexes'. I believe this is just an alert letting you know the Master database was checked for errors but the indexes were ignored.
-SQLBill
-SQLBill
- Status
Similar threads
- Locked
- Question