Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2010-02-10 : 11:13:04
|
| Team,My Transaction log have failed with error mess as followsSQL Backup failed with exit code: 1010 SQL error code: 4214 [SQLSTATE 42000] (Error 50000). The step failed. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-10 : 11:58:38
|
| How come you have so many failures in your systems? If we get one or two a YEAR I get nervous ... |
 |
|
|
james_wells
Yak Posting Veteran
55 Posts |
Posted - 2010-02-10 : 13:32:51
|
| SQL ERROR 4214 - NO CURRENT DATABASE BACKUPWere you trying to backup the transaction log ??Seems to suggest that there is no valid database backup and therefore will not let you backup the transaction log until a valid database backup has been performed. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-02-10 : 13:37:27
|
| So either someone has switched the DB to simple recovery and back to full or has run an explicit TRUNCATE LOG command. Either way, the log backups will only start working after a full backup is taken--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Transaction Log