Click here to Skip to main content
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 2: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 OriginalGriff 304
1 Sergey Alexandrovich Kryukov 255
2 Maciej Los 250
3 Shweta N Mishra 216
4 PIEBALDconsult 174
0 OriginalGriff 7,660
1 Sergey Alexandrovich Kryukov 7,072
2 DamithSL 5,586
3 Manas Bhardwaj 4,946
4 Maciej Los 4,665


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 11 Jul 2013
Copyright © CodeProject, 1999-2014
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