Click here to Skip to main content
11,934,783 members (42,808 online)
Rate this:
Please Sign up or sign in to vote.
See more: SQL
When am taking DB backup,i got below error.Can any one know if ldf file loss means how to recover.

Msg 3013, Level 16, State 1, Line 1BACKUP DATABASE is terminating abnormally.

Msg 9001, Level 21, State 1, Line 1The log for database 'TEST_DB' is not available.

Check the event log for related error messages.

Resolve any errors and restart the database.
Posted 11-Jul-13 2:40am
Zoltán Zörgő 11-Jul-13 7:54am
What was the recovery strategy of your database?
k87mani 11-Jul-13 9:04am
We are not using any strategy
Zoltán Zörgő 11-Jul-13 9:27am
Well, there is nothing like no strategy in sql server. You have to choose from one of these: simple, full, bulk. Which one do you have?
ryanb31 11-Jul-13 8:55am
Apparently you need the log file.
k87mani 11-Jul-13 9:03am
yes,we can't take db backup

ryanb31 11-Jul-13 9:17am
So, have you done what it says? Check the log for errors and fix them.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web03 | 2.8.151126.1 | Last Updated 11 Jul 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100