Link to home
Start Free TrialLog in
Avatar of awalkinthepark
awalkinthepark

asked on

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?
Avatar of awalkinthepark
awalkinthepark

ASKER

ALTER DATABASE <database> SET ONLINE;


Seems to be working.
Log shows it progress
ASKER CERTIFIED SOLUTION
Avatar of Marten Rune
Marten Rune
Flag of Sweden image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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