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 |
|
RogerSGI
Starting Member
9 Posts |
 Posted - 2008-10-09 : 13:36:21
|
| I come in this morning and one of the databases I notice no trans log bu was ran for a 12 hour period.All others ran fine except for our accounting database.We run a trans log backup every hour. Then this morning just after 9:30 a trans log backups and then the regular backup that should have ran at 10:05pm last night finishes.Of course everybody denies being in the app or didn't run anything out of the ordinaryJust checking |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
RogerSGI
Starting Member
9 Posts |
Posted - 2008-10-09 : 14:02:30
|
| All I'm seeing is everything that ran. Just this 12 hour gap on this one database |
 |
|
|
RogerSGI
Starting Member
9 Posts |
Posted - 2008-10-09 : 14:03:42
|
| Got it. Thanks for the help |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
RogerSGI
Starting Member
9 Posts |
Posted - 2008-10-09 : 15:40:50
|
| I looked into the Log folder.There was a Optimization that started for that database and it took 13 hours to rebuild the indexes for the tables.Because of that none of the trans or regular backup would run.Seems odd but everything looks good. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
RogerSGI
Starting Member
9 Posts |
Posted - 2008-10-10 : 09:19:10
|
| Nope.I do know that it started at 8:05pm ~13.5 hours later a trans backup was ran and then a complete backup. Which is around 9:32am?Trans are setup every hour and the complete is at 10:50pmNothing ran until the opt finished |
|
|
|
|
|
|
What would prevent a trans log from running?