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 «««12345»»

Database in Recovery mode Expand / Collapse
Author
Message
Posted Tuesday, January 21, 2014 9:44 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:27 AM
Points: 42,468, Visits: 35,539
The status is RECOVERING? Not anything else?

Post the error log?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1533242
Posted Tuesday, January 21, 2014 9:44 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 8:16 AM
Points: 564, Visits: 852
What is the output of this code (change the database name):
SELECT  state_desc
FROM sys.databases
where name = 'DatabaseName'





Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1533243
Posted Wednesday, January 22, 2014 7:25 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 6:29 AM
Points: 52, Visits: 176
HI,

I am happy to tell you, my database is up now.....
Online now.....

Thanks a lot for your support...


Thanks
Praneeth
Post #1533622
Posted Wednesday, January 22, 2014 7:27 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:27 AM
Points: 21,265, Visits: 14,964
That's good news. Glad it is working for you now.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1533625
Posted Wednesday, January 22, 2014 7:33 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 6:29 AM
Points: 52, Visits: 176
i am really tensed of my Job...

I got my database and job back
Post #1533632
Posted Wednesday, January 22, 2014 8:19 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 8:23 AM
Points: 15,533, Visits: 27,912
praneethydba (1/22/2014)
HI,

I am happy to tell you, my database is up now.....
Online now.....

Thanks a lot for your support...


Thanks
Praneeth


Congrats! That's great!

Now, run a backup.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1533666
Posted Wednesday, January 22, 2014 8:21 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:27 AM
Points: 21,265, Visits: 14,964
Grant Fritchey (1/22/2014)
praneethydba (1/22/2014)
HI,

I am happy to tell you, my database is up now.....
Online now.....

Thanks a lot for your support...


Thanks
Praneeth


Congrats! That's great!

Now, run a backup.


No, schedule regular backups and make sure they complete successfully.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1533671
Posted Wednesday, January 22, 2014 8:25 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 8:16 AM
Points: 246, Visits: 621
Good news!

I would document the incident, including timelines. The time that the database was offline has an associated cost. That is what you need to use when someone says that they can not afford hardware resources for backups.

Backups are insurance - you have a risk (losing data). To reduce that risk, you pay a premium (the costs of setting up the backups). And you hope that you never make a claim (database failure) but you sleep better at night knowing that you have managed the risk.

Good luck!
Post #1533678
Posted Wednesday, January 22, 2014 8:27 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 8:16 AM
Points: 564, Visits: 852
SQLRNNR (1/22/2014)
Grant Fritchey (1/22/2014)
praneethydba (1/22/2014)
HI,

I am happy to tell you, my database is up now.....
Online now.....

Thanks a lot for your support...


Thanks
Praneeth


Congrats! That's great!

Now, run a backup.


No, schedule regular backups and make sure they complete successfully.
Also get training resources for yourself and the developer that wrote the code to start a 24 hour transaction that never completed




Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1533681
Posted Wednesday, January 22, 2014 8:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 6:29 AM
Points: 52, Visits: 176
Ok Sure..Thanks
Post #1533697
« Prev Topic | Next Topic »

Add to briefcase «««12345»»

Permissions Expand / Collapse