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 |
|
venkateshdba10
Starting Member
1 Post |
 Posted - 2011-08-24 : 07:44:31
|
| HI, In my Office Environment,full backup scheduled at once a day and transactional log backup scheduled at every 15 minutes per day.yesterday,i saw the error message in error log that transactional log backup failed at 10.15 pm.but the next schedule was executed successfully (at 10.30 pm).i dont have the 15 minutes (10.15 to 10.30) log backup.how can i take the transactional log backup manually at the time interval 10.15 to 10.30 pm.s.venky |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-08-24 : 08:02:13
|
| Assuming that the log backup was NEVER created at 10:15 then then 10:30 backup would have included all transactions not already backed up - so everything from 10:00 to 10:15 and also from 10:15 to 10:30You may want to check why 10:15 job did not run though. Its possible that the 10:00 job was still running (e.g. a FULL backup on the database was running, and prevented the 10:00 transaction backup from completing (until after 10:15, and thus the 10:15 job never started).If the 10:15 job did indeed start then you may have a problem that you need to diagnose and fix. |
 |
|
|
|
|
|
Transactional Backup