• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

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

How do I reinitiate the recovery, now that disk space is available?
0
awalkinthepark
Asked:
awalkinthepark
1 Solution
 
awalkintheparkAuthor Commented:
ALTER DATABASE <database> SET ONLINE;


Seems to be working.
Log shows it progress
0
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
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
 
David ToddSenior DBACommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now