February 2, 2015 at 3:37 am
Will database id changes after sql server reboot ? my sql is rebooted y'day when I checked in logs and found
SQL Server must shut down in order to recover a database (database ID 30). The database is either a user database that could not be shut down or a system database. Restart SQL Server. If the database fails to recover after another startup, repair or restore the database.
but the database is not found with the id 30
any suggestions ?
February 2, 2015 at 4:00 am
It won't change the IDs on a reboot, no.
It sounds like you have a corrupt database. Do you regularly run DBCC CHECKDB on your databases? If not, I'd strongly suggest getting that in place. Also, I'd suggest validating that your backups are running and that you can restore your databases. You may be needing the restore operation soon.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 2, 2015 at 4:00 am
Weird duplicate post. Edited this to remove the repeated statements.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 2, 2015 at 4:02 am
Thanks for repling , what are the reasons for this error ?
February 2, 2015 at 4:06 am
and also the server is in mirroring which the error is occurred
February 2, 2015 at 4:20 am
Corruption, either disk or memory or some weird race condition perhaps.
Follow Grant's advice, if it happens again consider contacting Microsoft's customer support.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2015 at 5:02 am
Like Gail says. It sounds like something, unknown at this point, is wrong on your server. I'd get the consistency checks on all the databases, including the master, gets run first.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 2, 2015 at 5:52 am
This was removed by the editor as SPAM
February 2, 2015 at 6:37 am
jacksonandrew321 (2/2/2015)
I do agree with both Gail and Grant, u should check for DBCC and to know more about corruption reasons click here[/url]
Since that post is a thinly veiled advertisement for a data recovery tool, I don't recommend it. It teaches nothing about corruption, instead just describing page structures and is wrong in a few places.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2015 at 6:39 am
Is it the secondary or primary mirror copy that is having problems?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 2, 2015 at 9:25 pm
This was removed by the editor as SPAM
May 11, 2015 at 8:39 am
jacksonandrew321 (2/2/2015)
GilaMonster (2/2/2015)
jacksonandrew321 (2/2/2015)
I do agree with both Gail and Grant, u should check for DBCC and to know more about corruption reasons click here[/url]Since that post is a thinly veiled advertisement for a data recovery tool, I don't recommend it. It teaches nothing about corruption, instead just describing page structures and is wrong in a few places.
Gail, thats not about the tool, its about what it does and the content in entire post is explained accurately for which one of the corruption (reason) may be occurred. I found this post valuable related to the above query thats why posted here.
I completely agree with Gail.
Think this blog post still says that you can only have one clustered index per database.
Wish that was the only bad information in this blog.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply