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 |
|
rb1373
Yak Posting Veteran
93 Posts |
 Posted - 2004-12-17 : 11:59:25
|
| I have transaction log backups scheduled every 30 minutes between 7 AM and 6 PM. If the 5 PM transaction log backup fails and the full database backup doesn't occur until 9 PM, does this invalidate the entire transaction log sequence? I'm trying to determine how bad a transaction log failure is.Thanks! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-17 : 12:01:16
|
| The tr log backup failure shouldn't reset the lsn so the next rtl log backup should include all the transactions.Probably depends what the error is though.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rb1373
Yak Posting Veteran
93 Posts |
Posted - 2004-12-17 : 12:28:40
|
| This is the core of the error message: [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device '\\MyNAS\sql\apps\MyDB_tlog_200412161700.TRN'. Device error or device off-line. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-17 : 15:16:58
|
| Did you verify if that path and filename are valid? Can it be opened by the database server?Tara |
|
|
|
|
|
|
invalidated transaction log sequence?