Solution1.Run latest DBAnalyzer. Select 'DBUtilities >> Check Database Consistency' option and run it for all databases
The problem relates to corrupted tables in the BPRO database. .
The first option is to restore a fairly recent backup in which the DBCC Checkdb command does not report errors and then to update the database with transactions for the subsequent days.
The second option is to run the query given by us through query analyser.This solution given may result in a certain degree of data loss proportionate to the corruption of data.The extent and amount of data loss cannot be determined before running the query. Run the query given below from SQL Query Analyser after taking a backup and after obtaining permission from your divisional \ regional offices and informing them of the data loss which might occur.
sp_dboption 'bpro', 'single user', 'true'
go
dbcc checkdb ('bpro', REPAIR_ALLOW_DATA_LOSS)
go
sp_dboption 'bpro', 'single user', 'false'
go
The problem relates to corrupted tables in the BPRO database. .
The first option is to restore a fairly recent backup in which the DBCC Checkdb command does not report errors and then to update the database with transactions for the subsequent days.
The second option is to run the query given by us through query analyser.This solution given may result in a certain degree of data loss proportionate to the corruption of data.The extent and amount of data loss cannot be determined before running the query. Run the query given below from SQL Query Analyser after taking a backup and after obtaining permission from your divisional \ regional offices and informing them of the data loss which might occur.
sp_dboption 'bpro', 'single user', 'true'
go
dbcc checkdb ('bpro', REPAIR_ALLOW_DATA_LOSS)
go
sp_dboption 'bpro', 'single user', 'false'
go
No comments:
Post a Comment