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 |
|
MegaTrain
Starting Member
16 Posts |
 Posted - 2009-05-27 : 11:55:51
|
| On most of our SQL 2000 servers, we run transaction logs backups every 2 hrs, with the full backup sometime between 8pm and 4am, depending on the server. We haven't really worried about these two processes conflicting, but lately we've run into some of the following issues:1. On one server, the trans log backup occasionally blocks the full backup, and must be manually stopped before the full backup can complete2. We sometimes end up with a massively-sized trans log backup file (sometimes larger than the full backup!) that seems to occur at the same time the full backup is running.I found this chart that seems to say that these are "not allowed" to run at the same time, whatever that means: http://msdn.microsoft.com/en-us/library/aa213772(SQL.80).aspxSo, is this a known issue? Should we be explicitly stopping the log backups while the full backups are running?Secondly, is there an easy way to do so, short of modifying the schedule of jobs on 200+ servers? Can I have one job look to see if another job is already running before continuing?Thanks,BradC |
|
|
MegaTrain
Starting Member
16 Posts |
Posted - 2009-05-27 : 11:57:12
|
| Follow-up question: I posted this in SQL 2000 because that's where our primary errors are occuring. Would this advice be any different for a SQL 2005 or 2008 instance? |
 |
|
|
|
|
|
Trans log backups conflicting with Full backups?