RE: internal consistency error

From: Abid (anonymous_at_discussions.microsoft.com)
Date: 05/19/04 

Date: Wed, 19 May 2004 11:11:07 -0700

Hi,

Could you please confirm that the SQL Server is up and running and the database in question is online.

And you are unable to run DBCC CHECKDB(<db name>)

On doing so what error you get? On running DBCC CHECKDB does it shows some inconsistency and allocation error on the second last line of output...

Also look for errors in the SQL Server error log for this database.

Regards
Abid

Relevant Pages

  • Re: LOG Device Corrupted
    ... Check the documentation for the correct DBCC ... It seems your old database have mutiple LDF files. ... Stop sql server and rename the existing MDF to a new one and copy the ... Now execute the undocumented DBCC to create a log file ...
    (microsoft.public.sqlserver.server)
  • Re: torn page
    ... It is not required to make the SQL Server to start in single user mode. ... the DBCC with Rebuild option to sinlge user. ... How to make database to single user:- ...
    (microsoft.public.sqlserver.server)
  • Re: How do I shrink my logfile?
    ... > I followed the instructions in the link but when I run DBCC ... >> See DBCC SHRINKFILE in SQL Server Books Online. ... >> Is .NET important for a database professional? ...
    (microsoft.public.sqlserver.server)
  • Re: Users Logins
    ... >database - objects such as tables, views, stored ... >security topics in books online in order to be able to ... If you go into SQL Server books online, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server down
    ... All resources are online except SQL Server-failed and SQL Server Agent-offline ... see Help and Support Center at ... During redoing of a logged operation in database 'master', ...
    (microsoft.public.sqlserver.clustering)