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 12»»

DB in Recovery Pending Expand / Collapse
Author
Message
Posted Friday, July 11, 2014 2:57 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 2,598, Visits: 3,884
Hi Experts,

Our DW database having size 6TB is in recovery pending state because of space issue in that drive. How can we resolve this issue?

Since the db is not online we wont be able to add a new file to another drive right.

TIA
Post #1591489
Posted Friday, July 11, 2014 2:58 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 @ 3:30 PM
Points: 42,848, Visits: 35,977
What are the messages in 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 #1591490
Posted Friday, July 11, 2014 3:38 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 2,598, Visits: 3,884
Thanks a lot Gail.

S:\LOG\ABC_Log_508.ldf: Operating system error 112(There is not enough space on the disk.) encountered.

To allow recovery to succeed, the log file 'ABC_log5' has been expanded beyond its maximum size. After recovery completes, you should either increase the size of the log file in the database or schedule more frequent backups of the log (under the full or bulk-logged recovery model).
Post #1591505
Posted Friday, July 11, 2014 4:08 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 @ 3:30 PM
Points: 42,848, Visits: 35,977
Is that the only message?

Can you move files off S drive to free up space?



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 #1591535
Posted Friday, July 11, 2014 4:32 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 2,598, Visits: 3,884
Only mdf and ldf files of that particular db exists in that drive.
Post #1591542
Posted Friday, July 11, 2014 4:59 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 @ 3:30 PM
Points: 42,848, Visits: 35,977
Can you expand the drive?


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 #1591554
Posted Friday, July 11, 2014 7:46 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 2,598, Visits: 3,884
We have requested infrastructure team for that..

Is there any other way to handle this.


Thanks Again Gail.. You are my Guru..


Post #1591640
Posted Friday, July 11, 2014 8:00 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 @ 3:30 PM
Points: 42,848, Visits: 35,977
Probably, but they're far less preferable ways than expanding the drive.


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 #1591642
Posted Monday, July 14, 2014 7:12 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 10:36 PM
Points: 24, Visits: 255
What is the recovery model of the dw?

SQL Server Best Practices Supporter
Post #1592392
Posted Tuesday, July 15, 2014 12:59 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 2,598, Visits: 3,884
Shaun Finnegan (7/14/2014)
What is the recovery model of the dw?


Simple Recovery
Post #1592420
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse