Solved

SQL server database in recover fails when machine runs out of disk space

Posted on 2013-05-10
3
341 Views
Last Modified: 2013-05-12
How do I reinitiate the recovery, now that disk space is available?
0
Comment
Question by:awalkinthepark
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 

Author Comment

by:awalkinthepark
ID: 39157256
ALTER DATABASE <database> SET ONLINE;


Seems to be working.
Log shows it progress
0
 
LVL 20

Accepted Solution

by:
Marten Rune earned 500 total points
ID: 39157965
Im not at office, but:
Restore <database> WITH recovery
Works, in spite of no logbackup or backup files mentioned.
If it halted during a point in time restore, you can simply use the same command, it will pick up the correct place to restore from using rhe LSN it previously restored to.
Regards Marten
0
 
LVL 35

Expert Comment

by:David Todd
ID: 39159886
Hi,

Something you should do daily imho is to monitor available disk space (as a percentage) on all disks on each database server ...

Regards
  David
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Using this function 4 39
IF SQL Query 12 27
How to embedded  excel formula with excel report  generated by SSRS 2 13
SQL 2012 Instance Problem 3 48
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question