Click here to Skip to main content
11,711,750 members (77,765 online)
Rate this: bad
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 1:40am
Zoltán Zörgő at 11-Jul-13 7:54am
What was the recovery strategy of your database?
k87mani at 11-Jul-13 9:04am
We are not using any strategy
Zoltán Zörgő at 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 at 11-Jul-13 8:55am
Apparently you need the log file.
k87mani at 11-Jul-13 9:03am
yes,we can't take db backup

ryanb31 at 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
0 Sergey Alexandrovich Kryukov 434
1 CHill60 280
2 OriginalGriff 170
3 Peter Leow 130
4 Abhinav S 125
0 CHill60 280
1 Sergey Alexandrovich Kryukov 125
2 Andy Lanng 120
3 Abhinav S 95
4 Maciej Los 95

Advertise | Privacy | Mobile
Web02 | 2.8.150819.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