That bad disk may have munged more than one of your databases.Įrland Sommarskog, SQL Server MVP, crying out loud! Don't you have any shame! I would also suggest that you run DBCC CHECKDB on the other databases on the server. What does the end of the output from DBCC say? More precisely, which repair level does it indicate? If it suggest REPAIR_ALLOW_DATA_LOSS, you will need to investigate your earlier backups of the database to find one which is clean. Most likely, if you restore the database on a different server and run DBCC CHECKDB, you will find the same error messages. That new backup is not likely to be extremely useful. no worries as i have new backup of database. But, as suggested here i have run the DBCC CHECKDB on my Database and its giving me hundreds of error messages and 3 consistency errors. Actually doing a disk fragmentation on which the database resides resolved issue.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |