September 23, 2010 at 3:19 am
Hello,
Why database getting suspended stage?
How can we solve this?
What are all the problem we will get this error?
could you please give some guide on this.
Thanks,
ARP
September 23, 2010 at 3:40 am
Where are you seeing that status?
What errors/messages are you seeing?
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
September 23, 2010 at 4:58 am
hi,
When i came in the morning one of the db was showing Suspended mode..
after that i have taken care of that.
could you please let me know why we get this error?
how should not repeat same error in the future?
Thanks
ARP
September 23, 2010 at 5:02 am
No idea, because I'm still not sure what you're referring to.
Suspended is not a state for a database. (Online, restoring, recovering, recovery_pending, suspect, emergency and offline are)
Where did you see that indicator.
When you say you took care of it, what do you mean?
Anything in the SQL error log?
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
September 23, 2010 at 5:07 am
hi,
When i got this error,I ran following queries and DB back.
EXEC sp_resetstatus 'yourDBname';
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER
Thanks
ARP
September 23, 2010 at 5:09 am
there are lot of reason the database goes to suspond mode
data page corruption, Log file grows and do not have space on the disk,may your t-log got currputed.
Regards,
Subbu
Click here to Get Speedy answer or solution
September 23, 2010 at 5:21 am
antonyp 46888 (9/23/2010)
hi,When i got this error,I ran following queries and DB back.
EXEC sp_resetstatus 'yourDBname';
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER
Thanks
ARP
Do not follow this advice.
I'd suggest giving some more information so people can help.
As Gail said, "Suspended" is not a database state. What's the exact wording that appears next to the database name in Management Studio?
September 23, 2010 at 5:41 am
subbu_e (9/23/2010)
Log file grows and do not have space on the disk.
That will not result in a database being marked suspect.
Also, there's no indication that the database actually was suspect.
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
September 23, 2010 at 5:44 am
HowardW (9/23/2010)
As Gail said, "Suspended" is not a database state. What's the exact wording that appears next to the database name in Management Studio?
And what messages appear in the SQL error log?
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
May 20, 2013 at 10:40 am
Just to follow up on what I see in terms of mirroring with suspended:
My Query:
select d.name, p.mirroring_role_desc, p.mirroring_state_desc from sys.database_mirroring p join sys.databases d on p.database_id = d.database_id where p.mirroring_guid is not null
Result is: The mirroring_state_desc status of suspended I don't think this is a good mirror state.
namemirroring_role_descmirroring_state_desc
ReportServerMIRRORSUSPENDED
ReportServerTempDBMIRRORSUSPENDED
Application_Registry_Service_DB_304289c1bbf94d2f935ecffa00a75ce8MIRRORSUSPENDED
Bdc_Service_DB_7549a6a9476d467f9809218279e6abd5MIRRORSUSPENDED
Managed Metadata Service_82b3afbf3c314e79a73fdd4f40445fb1MIRRORSUSPENDED
PerformancePoint Service Application_d510ae20933e409aa777b2fbcb44934fMIRRORSUSPENDED
Search_Service_Application_DB_edad6400e4f14bd084c0794460876142MIRRORSUSPENDED
Search_Service_Application_PropertyStoreDB_3c0beb0dc4014855abcbe9c6f7d990ecMIRRORSUSPENDED
Secure_Store_Service_DB_53e96e35ba1b4dac9a5db50f813d9394MIRRORSUSPENDED
SharePoint_AdminContent_6f803c50-c552-47aa-b3fe-50a9609a4169MIRRORSUSPENDED
SharePoint_ConfigMIRRORSUSPENDED
StateService_1a26bfca5ab3497a83292ee801684443MIRRORSUSPENDED
User Profile Service Application_ProfileDB_21cc18205a6e499d8616cde632792a00MIRRORSUSPENDED
User Profile Service Application_SocialDB_3c4d6eefe1fe4eeea6a3dcdcf3f8b477MIRRORSUSPENDED
WebAnalyticsServiceApplication_ReportingDB_ddd28709-c53c-4e53-8525-182c77ff57e7MIRRORSUSPENDED
WordAutomationServices_1fe0878dc98f48eb8db44bb729d84de0MIRRORSUSPENDED
WSS_ContentMIRRORSUSPENDED
WSS_Content_64_2009MIRRORSUSPENDED
May 20, 2013 at 11:06 am
Please note: 3 year old thread that was not about mirroring.
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
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply