Error 615 When Running Any Statements Against Table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » Data Corruption (SS2K8 / SS2K8 R2) » Error 615 When Running Any Statements Against...

Error 615 When Running Any Statements Against Table

Rate Topic

Display Mode

Topic Options

Author

Message

matt-996958

Posted Tuesday, September 04, 2012 10:04 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 3:38 PM
Points: 6, Visits: 72

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

Robert Davis

Posted Thursday, September 06, 2012 12:47 AM

SSCommitted

Group: General Forum Members
Last Login: Sunday, May 19, 2013 8:09 AM
Points: 1,558, Visits: 1,396

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
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring

Post #1355057

« Prev Topic | Next Topic »

Permissions