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 |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2006-12-22 : 16:25:46
|
| Can full and trans log back up can be run at the same time?My full backup job ran 2:00 amand trans log backup run from 6 am to 5 am every hour.Is it ok? |
|
|
jung1975
Aged Yak Warrior
503 Posts |
Posted - 2006-12-22 : 16:32:46
|
| alos i run DBCC check DB at 12:oo am |
 |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2006-12-22 : 19:00:33
|
| It is OK...In sql server 2000 you can't run both backups at the same time...Even if you start full backup will block tlog backup...Where as in 2005 I think tlog can be completed while full is running...Checkdb can run during full backup too..MohammedU |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-23 : 02:41:18
|
| It would be better to run the TLog backup just before the Full backup IMO (e.g. schedule the Full Backup for 5 minutes later)Reason being: if you have to restore from Full plus Tlog the smaller your Tlog is the less work SQL Server has to do. So if you back up TLog just AFTER Full then there is a whole extra hour's redundant data in the TLog backup that Restore has to work through.Its a small point, of course, but IME Restore is a time-critical task and every little helps.Kristen |
|
|
|
jung1975
Aged Yak Warrior
503 Posts |
Posted - 2006-12-26 : 14:40:16
|
| Kristen/MohammedU - I am doing trans back up every hour 6am ~5amand full back up at 2:30 am .Does it sounds ok? |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-12-26 : 15:09:58
|
| It is better to backup the transaction log more often than once per hour. I recommend at least every 15 minutes.There is no problem with running them at the same time. At worst, the transaction log backup will just wait until the full backup completes.CODO ERGO SUM |
|
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2006-12-26 : 15:53:52
|
| Jung,I don't see any problem with your schedule...As Michael mentioned you can change the tlog frequency but it depends on your company's policy... If your company can efford to loose 1 hour data incase of disaster it should be fine or you may need to reduce the frequency...MohammedU |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-27 : 02:44:23
|
| Seems like I'm banging the same drum here ... but I can't think of circumstances where it is acceptable to lose 1 hours data when TLog backups could be set up to run every 10 minutes and only lose 10 minutes data ... perhaps someone can enlighten me pls?Kristen |
|
|
|
|
|
|
Full back up and trans back up