Click here to Skip to main content
11,577,258 members (53,535 online)
Rate this: bad
good
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
k87mani604
Comments
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
   
@ryanb31
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 DamithSL 155
1 Afzaal Ahmad Zeeshan 125
2 OriginalGriff 115
3 Richard MacCutchan 100
4 Abhinav S 90
0 OriginalGriff 820
1 Sergey Alexandrovich Kryukov 676
2 Abhinav S 528
3 F-ES Sitecore 420
4 Suvendu Shekhar Giri 375


Advertise | Privacy | Mobile
Web03 | 2.8.150603.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