SQL database suspect status, Help!!!# Database - 数据库
a*e
1 楼
I have a database that was marked by the system as
"suspect". I tried to recover it as what SQL bookonline
said. But it didn't work. The error message in the error log
is as follows:
udopen [filename] incorrect size(10240 2k pages should be
10752)
The data file associated with this database is
2*10240K=20M. But the size the database device for it is
10752*2K=21M. I can't change the database device size to
20M.
Could you please help me? I really don't want to drop
this database.
BTW
"suspect". I tried to recover it as what SQL bookonline
said. But it didn't work. The error message in the error log
is as follows:
udopen [filename] incorrect size(10240 2k pages should be
10752)
The data file associated with this database is
2*10240K=20M. But the size the database device for it is
10752*2K=21M. I can't change the database device size to
20M.
Could you please help me? I really don't want to drop
this database.
BTW