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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-05 : 08:19:14
|
| lba writes "BACKUP failed to complete the command BACKUP LOG [HEAT] TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\HEAT\HEAT_tlog_200211011400.TRN' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT" |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2002-11-05 : 08:46:39
|
| lba, please check DB options:In SQL 2K you cannot backup t-log if recovery model is set to simple.In SQK 7 you cannot backup t-log if "truncate log on checkpoint" is set to true.HTH.Franco |
 |
|
|
|
|
|
backup failure