Solved

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

Posted on 2013-05-10
3
337 Views
Last Modified: 2013-05-12
How do I reinitiate the recovery, now that disk space is available?
0
Comment
Question by:awalkinthepark
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now