Skip to main content
Database Administrators

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

6
  • 1
    The LDF is 13 GB while the backup is only 200MB. His LDF is mostly empty and space has only been reserved and set with an initial size of 13GB or it auto grew because at some point there were a lot of transactions being recorded in the LDF Commented Oct 23, 2015 at 12:31
  • @user2347976 If this is critical data then you definitely need to change that strategy you're using. I do at a minimum FULL backups once a day and then LOG backups hourly or more often depending on the applications they're tied to, etc., how critical they are for the business, etc. You have to plan ahead of time and ensure you understand how to restore as knowing how to backup and assuming will getcha sometimes when it's too late. . . You have to do your homework and be proactive if this is driving critical business processes or applications. Good luck! Commented Oct 23, 2015 at 19:02
  • @Peter Elzinga But on this thread at social.msdn.microsoft.com/Forums/sqlserver/en-US/…, MS employee David said it is possible to restore Oct 5 point. I get confused. Commented Oct 24, 2015 at 4:17
  • @user2347976 David is right, I never knew this was possible. I will change my answer accordingly. Commented Oct 26, 2015 at 7:49
  • @Peter Elzinga Thank you for your modifications Commented Oct 26, 2015 at 12:03