MS SQL is a
well known RDBMS using which you can store and manage huge amount of
data and can also modify when you needs. It makes use of Transaction
log to keeps track of all modifications that takes place in database
as well as store them in separate files so that it can be easily
access. Transaction log also acts as backup file. So, if in case any
mishaps takes place you can restore it. But sometimes it happens that
the log gets corrupt and this gives rise to SQL error 9004 when you
try to access it. You will get the following error message:-
Error: 9004,
Severity: 21, State: 1.
SQL error
9004 disallows you to perform database recovery. In such cases to
perform SQL recovery again you need to repair the damaged database
and transaction log. That may be number of reasons. Some common of
them are:-
Use of
outdated device drivers
Defect in
SQL engine
Virus attack
Damaged file
headers
Corrupt .mdf
file
Improper
functioning of hardware
Use DBCC
CHECKDB REPAIR_ALLOW_DATA_LOSS command to repair damaged database. If
the command not works then try MS SQL Database Repair software to
Restore Database Due to SQL Error 9004.
0 comments:
Post a Comment