Error while shrinking database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Error while shrinking database

Author

Topic

eldhose
Starting Member

14 Posts

Posted - 2005-10-13 : 07:04:29

Hi,

When I am trying to shrink a database, I got the following error.

Executed as user: NT AUTHORITY\SYSTEM. ...he PageId in the page header = (0:0). [SQLSTATE 42000] (Error 8909) Table error: Object ID 0, index ID 0, page ID (1:491894). The PageId in the page header = (0:0). [SQLSTATE 42000] (Error 8909) Table error: Object ID 0, index ID 0, page ID (1:491893). The PageId in the page header = (0:0). [SQLSTATE 42000] (Error 8909) Table error: Object ID 0, index ID 0, page ID (1:491892). The PageId in the page header = (0:0). [SQLSTATE 42000] (Error 8909) Table error: Object ID 0, index ID 0, page ID (1:491891). The PageId in the page header = (0:0). [SQLSTATE 42000] (Error 8909) Table error: Object ID 0, index ID 0, page ID (1:491890). The PageId in the page header = (0:0). [SQLSTATE 42000] (Error 8909) Table error: Object ID 0, index ID 0, page ID (1:491889). The PageId in the page header = (0:0). [SQLSTATE 42000] (Error 8909) Table error: Object ID 0, index ID 0, page ID (1:490615). The PageId in the page header = (0:0). [SQLSTATE 42000] (Error 8...

Please help me to resolve this issue

Thanks & Regards,
Eldho Abraham

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-10-13 : 12:37:09

Eldho,

You've got corruption in your database. Can you post the output from
DBCC CHECKDB (dbname) WITH ALL_ERRORMSGS, NO_INFOMSGS

Any evidence of h/w issues in the Windows event logs or SQL errorlog?

Any other runtime errors?

Thanks

Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

eldhose
Starting Member

14 Posts

Posted - 2005-10-16 : 06:13:57

Hi,
There is no error reported in the Windows event logs or SQL errorlog. ALso there is no run time error.

Please find the output of

DBCC CHECKDB (dbname) WITH ALL_ERRORMSGS, NO_INFOMSGS

The command(s) completed successfully.

Regards,
Eldho Abraham

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-10-16 : 10:49:56

All I can think of is that you did have corruption in a table but shrink has removed it. If CHECKDB isn't returning any errors then things are ok now.

I'd keep a close watch on that database.

Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

eldhose
Starting Member

14 Posts

Posted - 2005-10-17 : 08:29:13

Hi,

Though there is no consistency error, the free space is around 2.5 gb. When i tried to shrink the database through enterprise manager, i am getting following error

"Error 8909 : Table Error : Object ID 0, Index ID 0, Page Id (1:491895) The PageId in the Page Header = (0:0)"

Thanks & regards,
Eldho

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-10-17 : 12:02:45

Can you post results from

DBCC PAGE (dbname, 1, 491895, 1)

Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

eldhose
Starting Member

14 Posts

Posted - 2005-10-18 : 10:32:57

Hi

The output of the DBCC PAGE (dbname, 1, 491895, 1)

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Regards,
Eldho Abraham

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-10-18 : 12:33:24

Do a DBCC TRACEON (3604, -1) first please so the output doesn't go to the errorlog.

Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources