Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error 615 When Running Any Statements Against Table Expand / Collapse
Author
Message
Posted Tuesday, September 4, 2012 10:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 3, 2013 1:17 PM
Points: 10, Visits: 83
Hello,

I am running into an issue where whenever I run any type of statement against one of the tables in my DB I get the following error:

Msg 615, Level 21, State 1, Line 1
Could not find database ID 489, name '489'. The database may be offline. Wait a few minutes and try again.

I have run DBCC CHECKDB and CHECKTABLE, when I try to re-index it throws the above error. I tried to delete the table so I could recreate from backup but received the above error.

Thanks
Post #1354022
Posted Thursday, September 6, 2012 12:47 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 9, 2014 12:08 PM
Points: 1,618, Visits: 1,553
You should open a case with Microsoft PSS.

Found these 2 relevant Connect items and both point to contacting PSS: http://connect.microsoft.com/SQLServer/feedback/details/529716/problem-with-cannot-find-database-id-0-the-database-may-be-offline and http://connect.microsoft.com/SQLServer/feedback/details/694675/could-not-find-database-id-0-name-dbname-the-database-may-be-offline-wait-a-few-minutes-and-try-again




My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1355057
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse