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 |
|
kensai
Posting Yak Master
172 Posts |
 Posted - 2010-09-30 : 04:45:58
|
| I'm going to schedule a differential backup at 01AM and transaction log backup every one hour for a database. What will happen differential backup takes too long and transaction log backup starts while differential backup still running?Also same question but with full backups. What will happen a transaction log backup starts while the database is still in the process of making a full backup?If it matters, the scheduled jobs are going to run as sql scripts in management->plan->Execute T-SQL Statement Task. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-09-30 : 07:59:47
|
| What version of SQL?--Gail ShawSQL Server MVP |
 |
|
|
kensai
Posting Yak Master
172 Posts |
Posted - 2010-09-30 : 09:21:09
|
quote:
Originally posted by GilaMonster
What version of SQL?--Gail ShawSQL Server MVP
2005 Standart |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-09-30 : 13:19:21
|
| No concerns then. The backups can run simultaneously.--Gail ShawSQL Server MVP |
|
|
|
kensai
Posting Yak Master
172 Posts |
Posted - 2010-10-01 : 07:32:03
|
quote:
Originally posted by GilaMonster
No concerns then. The backups can run simultaneously.--Gail ShawSQL Server MVP
Thank you. |
|
|
|
|
|
|
Running two kinds of backup at the same time