Skip to main content
edited body
Source Link
J.D.
  • 39.5k
  • 12
  • 60
  • 134

Likely the reason your Transaction Log backup is taking much longer to run than usual is because it has a lot more data to backup - all of the transactions that haven't been backed up yet since the last time a Transaction Log backup was ran three weeks ago.

Please see my answer to a related question that explains a little bit of how the Transaction Log works and what causes the log file to grow.

But in short, independent of when your Full backup runs, your Transaction Log backups are dependent on the unbacked up transactions in the log file, which accumulate until a Transaction Log backup is taken. Once a Transaction Log backup is taken, the transactions in the log file are marked for re-use which allows them to be overwritten by new transactions. This can only happen as a result of a Transaction Log backup occuring, a Full backup doesn't backup the log file (it only backs up the database's data file).

This explains why your log file grew so much over the last few weeks. New transactions will continue to append to the log file until it's backed up and the old transactions are marked for re-use such that they can be overwritten instead.

Q: "Any potential issues to consider?"

A: No immediate issues that I can think of. The only issue that can occur is if you have an event that requires point in time recovery, you wouldn't have any Transaction Log backups to get you to a specific restore point in time (within the last three weeks), the. The best you'd be able to do is the timestamp of the Full backup you took already, and once your current Transaction Log backup finishes, that'll be the most granular point in time you'll be able to recover to until your next Transaction Log backup runs (which should complete a lot quicker since it won't have three weeks of transactions to backup).

Likely the reason your Transaction Log backup is taking much longer to run than usual is because it has a lot more data to backup - all of the transactions that haven't been backed up yet since the last time a Transaction Log backup was ran three weeks ago.

Please see my answer to a related question that explains a little bit of how the Transaction Log works and what causes the log file to grow.

But in short, independent of when your Full backup runs, your Transaction Log backups are dependent on the unbacked up transactions in the log file, which accumulate until a Transaction Log backup is taken. Once a Transaction Log backup is taken, the transactions in the log file are marked for re-use which allows them to be overwritten by new transactions. This can only happen as a result of a Transaction Log backup occuring, a Full backup doesn't backup the log file (it only backs up the database's data file).

This explains why your log file grew so much over the last few weeks. New transactions will continue to append to the log file until it's backed up and the old transactions are marked for re-use such that they can be overwritten instead.

Q: "Any potential issues to consider?"

A: No immediate issues that I can think of. The only issue that can occur is if you have an event that requires point in time recovery, you wouldn't have any Transaction Log backups to get you to a specific restore point in time (within the last three weeks), the best you'd be able to do is the timestamp of the Full backup you took already, and once your current Transaction Log backup finishes, that'll be the most granular point in time you'll be able to recover to until your next Transaction Log backup runs (which should complete a lot quicker since it won't have three weeks of transactions to backup).

Likely the reason your Transaction Log backup is taking much longer to run than usual is because it has a lot more data to backup - all of the transactions that haven't been backed up yet since the last time a Transaction Log backup was ran three weeks ago.

Please see my answer to a related question that explains a little bit of how the Transaction Log works and what causes the log file to grow.

But in short, independent of when your Full backup runs, your Transaction Log backups are dependent on the unbacked up transactions in the log file, which accumulate until a Transaction Log backup is taken. Once a Transaction Log backup is taken, the transactions in the log file are marked for re-use which allows them to be overwritten by new transactions. This can only happen as a result of a Transaction Log backup occuring, a Full backup doesn't backup the log file (it only backs up the database's data file).

This explains why your log file grew so much over the last few weeks. New transactions will continue to append to the log file until it's backed up and the old transactions are marked for re-use such that they can be overwritten instead.

Q: "Any potential issues to consider?"

A: No immediate issues that I can think of. The only issue that can occur is if you have an event that requires point in time recovery, you wouldn't have any Transaction Log backups to get you to a specific restore point in time (within the last three weeks). The best you'd be able to do is the timestamp of the Full backup you took already, and once your current Transaction Log backup finishes, that'll be the most granular point in time you'll be able to recover to until your next Transaction Log backup runs (which should complete a lot quicker since it won't have three weeks of transactions to backup).

added 666 characters in body
Source Link
J.D.
  • 39.5k
  • 12
  • 60
  • 134

Likely the reason your Transaction Log backup is taking much longer to run than usual is because it has a lot more data to backup - all of the transactions that haven't been backed up yet since the last time a Transaction Log backup was ran three weeks ago.

Please see my answer to a related question that explains a little bit of how the Transaction Log works and what causes the log file to grow.

But in short, independent of when your Full backup runs, your Transaction Log backups are dependent on the unbacked up transactions in the log file, which accumulate until a Transaction Log backup is taken. Once a Transaction Log backup is taken, the transactions in the log file are marked for re-use which allows them to be overwritten by new transactions. This can only happen as a result of a Transaction Log backup occuring, a Full backup doesn't backup the log file (it only backs up the database's data file).

This explains why your log file grew so much over the last few weeks. New transactions will continue to append to the log file until it's backed up and the old transactions are marked for re-use such that they can be overwritten instead.

Q: "Any potential issues to consider?"

A: No immediate issues that I can think of. The only issue that can occur is if you have an event that requires point in time recovery, you wouldn't have any Transaction Log backups to get you to a specific restore point in time (within the last three weeks), the best you'd be able to do is the timestamp of the Full backup you took already, and once your current Transaction Log backup finishes, that'll be the most granular point in time you'll be able to recover to until your next Transaction Log backup runs (which should complete a lot quicker since it won't have three weeks of transactions to backup).

Likely the reason your Transaction Log backup is taking much longer to run than usual is because it has a lot more data to backup - all of the transactions that haven't been backed up yet since the last time a Transaction Log backup was ran three weeks ago.

Please see my answer to a related question that explains a little bit of how the Transaction Log works and what causes the log file to grow.

But in short, independent of when your Full backup runs, your Transaction Log backups are dependent on the unbacked up transactions in the log file, which accumulate until a Transaction Log backup is taken. Once a Transaction Log backup is taken, the transactions in the log file are marked for re-use which allows them to be overwritten by new transactions. This can only happen as a result of a Transaction Log backup occuring, a Full backup doesn't backup the log file (it only backs up the database's data file).

This explains why your log file grew so much over the last few weeks. New transactions will continue to append to the log file until it's backed up and the old transactions are marked for re-use such that they can be overwritten instead.

Likely the reason your Transaction Log backup is taking much longer to run than usual is because it has a lot more data to backup - all of the transactions that haven't been backed up yet since the last time a Transaction Log backup was ran three weeks ago.

Please see my answer to a related question that explains a little bit of how the Transaction Log works and what causes the log file to grow.

But in short, independent of when your Full backup runs, your Transaction Log backups are dependent on the unbacked up transactions in the log file, which accumulate until a Transaction Log backup is taken. Once a Transaction Log backup is taken, the transactions in the log file are marked for re-use which allows them to be overwritten by new transactions. This can only happen as a result of a Transaction Log backup occuring, a Full backup doesn't backup the log file (it only backs up the database's data file).

This explains why your log file grew so much over the last few weeks. New transactions will continue to append to the log file until it's backed up and the old transactions are marked for re-use such that they can be overwritten instead.

Q: "Any potential issues to consider?"

A: No immediate issues that I can think of. The only issue that can occur is if you have an event that requires point in time recovery, you wouldn't have any Transaction Log backups to get you to a specific restore point in time (within the last three weeks), the best you'd be able to do is the timestamp of the Full backup you took already, and once your current Transaction Log backup finishes, that'll be the most granular point in time you'll be able to recover to until your next Transaction Log backup runs (which should complete a lot quicker since it won't have three weeks of transactions to backup).

added 4 characters in body
Source Link
J.D.
  • 39.5k
  • 12
  • 60
  • 134

Likely the reason your Transaction Log backup is taking much longer to run than usual is because it has a lot more data to backup - all of the transactions that haven't been backed up yet since the last time a Transaction Log backup was ran three weeks ago.

Please see my answer to a related question that explains a little bit of how the Transaction Log works and what causes the log file to grow.

But in short, independent of when your Full backup runs, your Transaction Log backups are dependent on the unbacked upunbacked up transactions in the log file, which accumulate until a Transaction Log backup is taken. Once a Transaction Log backup is taken, the transactions in the log file are marked for re-use which allows them to be overwritten by new transactions. This can only happen as a result of a Transaction Log backup occuring, a Full backup doesn't backup the log file (it only backs up the database's data file).

This explains why your log file grew so much over the last few weeks. New transactions will continue to append to the log file until it's backed up and the old transactions are marked for re-use such that they can be overwritten instead.

Likely the reason your Transaction Log backup is taking much longer to run than usual is because it has a lot more data to backup - all of the transactions that haven't been backed up yet since the last time a Transaction Log backup was ran three weeks ago.

Please see my answer to a related question that explains a little bit of how the Transaction Log works and what causes the log file to grow.

But in short, independent of when your Full backup runs, your Transaction Log backups are dependent on the unbacked up transactions in the log file, which accumulate until a Transaction Log backup is taken. Once a Transaction Log backup is taken, the transactions in the log file are marked for re-use which allows them to be overwritten by new transactions.

Likely the reason your Transaction Log backup is taking much longer to run than usual is because it has a lot more data to backup - all of the transactions that haven't been backed up yet since the last time a Transaction Log backup was ran three weeks ago.

Please see my answer to a related question that explains a little bit of how the Transaction Log works and what causes the log file to grow.

But in short, independent of when your Full backup runs, your Transaction Log backups are dependent on the unbacked up transactions in the log file, which accumulate until a Transaction Log backup is taken. Once a Transaction Log backup is taken, the transactions in the log file are marked for re-use which allows them to be overwritten by new transactions. This can only happen as a result of a Transaction Log backup occuring, a Full backup doesn't backup the log file (it only backs up the database's data file).

This explains why your log file grew so much over the last few weeks. New transactions will continue to append to the log file until it's backed up and the old transactions are marked for re-use such that they can be overwritten instead.

Source Link
J.D.
  • 39.5k
  • 12
  • 60
  • 134
Loading