Restore job run successfully without error but actually not applied during log ship from older version to...
Arizona laws regarding ownership of ground glassware for chemistry usage
Why is quixotic not Quixotic (a proper adjective)?
Boiling meatballs, how long?
Discouraging missile alpha strikes
Short Story - Man lives in isolation in a compound, plays tennis against a robot, arranges meeting with a woman
Rudeness by being polite
Could Comets or Meteors be used to Combat Global Warming?
Is Apex Sometimes Case Sensitive?
Was Opportunity's last message to Earth "My battery is low and it's getting dark"?
Which was the first story to feature space elevators?
Proof of an integral property
How to not forget my phone in the bathroom?
How can I make my enemies feel real and make combat more engaging?
Why didn't Lorentz conclude that no object can go faster than light?
Why is Shelob considered evil?
How should I ship cards?
Run a command that requires sudo after a time has passed
Why does finding small effects in large studies indicate publication bias?
How can changes in personality/values of a person who turned into a vampire be explained?
Sauna: Wood does not feel so hot
Build ASCII Podiums
How sharp are RAW photos before processing?
Is it possible to detect 100% of SQLi with a simple regex?
What caused Doctor Strange to repent of his selfishness and become Earth's protector?
Restore job run successfully without error but actually not applied during log ship from older version to newer one
Our requirement is to 2008R2 databases to be upgraded/migrated to 2016. We want to configure log shipping between
2008r2(source) and 2016(target). We have also need to open these standby database after a long time (For example 1 month)
while while transaction logs will be deleted after 2 days then how is it possible?
log-shipping
asked 2 mins ago
safi qadrisafi qadri
213
add a comment |
Our requirement is to 2008R2 databases to be upgraded/migrated to 2016. We want to configure log shipping between
2008r2(source) and 2016(target). We have also need to open these standby database after a long time (For example 1 month)
while while transaction logs will be deleted after 2 days then how is it possible?
log-shipping
asked 2 mins ago
safi qadrisafi qadri
213
Currently we have configured 2 test instances using NORECOVERY option with Log Shopping jobs – Backup, Copy and Restore setup to run every hour while Log history of these three jobs shows no error. i.e. Backup executes successfully on 2008R2 instance, Copy and Restore jobs execute fine on 2016.
– safi qadri
2 mins ago
However, when we check the timestamp of data and log files of the configured databases on 2016, it shows the timestamp when this was configured. It seems transaction logs are not being applied. Also, when we try to open the database on 2016 using Restore -> Database, it reports some transaction log missing (because we configured to delete older than 2 days transaction logs and hence these were deleted after 2 days).
– safi qadri
2 mins ago
It seems that at the time of database open on 2016, it actually applies/restores transaction log files. Please confirm! Would you please show whether there is any way it can apply transaction logs while in this UPGRADE setup as explained above and let older than 2 days transaction log files deleted as per scheduled till we actually upgrade to 2016?
– safi qadri
1 min ago
add a comment |
Our requirement is to 2008R2 databases to be upgraded/migrated to 2016. We want to configure log shipping between
2008r2(source) and 2016(target). We have also need to open these standby database after a long time (For example 1 month)
while while transaction logs will be deleted after 2 days then how is it possible?
log-shipping
asked 2 mins ago
safi qadrisafi qadri
213
Our requirement is to 2008R2 databases to be upgraded/migrated to 2016. We want to configure log shipping between
2008r2(source) and 2016(target). We have also need to open these standby database after a long time (For example 1 month)
while while transaction logs will be deleted after 2 days then how is it possible?
log-shipping
log-shipping
asked 2 mins ago
safi qadrisafi qadri
213
asked 2 mins ago
safi qadrisafi qadri
213
asked 2 mins ago
safi qadrisafi qadri
213
asked 2 mins ago
safi qadrisafi qadri
213
asked 2 mins ago
safi qadrisafi qadri
213
213
Currently we have configured 2 test instances using NORECOVERY option with Log Shopping jobs – Backup, Copy and Restore setup to run every hour while Log history of these three jobs shows no error. i.e. Backup executes successfully on 2008R2 instance, Copy and Restore jobs execute fine on 2016.
– safi qadri
2 mins ago
However, when we check the timestamp of data and log files of the configured databases on 2016, it shows the timestamp when this was configured. It seems transaction logs are not being applied. Also, when we try to open the database on 2016 using Restore -> Database, it reports some transaction log missing (because we configured to delete older than 2 days transaction logs and hence these were deleted after 2 days).
– safi qadri
2 mins ago
It seems that at the time of database open on 2016, it actually applies/restores transaction log files. Please confirm! Would you please show whether there is any way it can apply transaction logs while in this UPGRADE setup as explained above and let older than 2 days transaction log files deleted as per scheduled till we actually upgrade to 2016?
– safi qadri
1 min ago
add a comment |
Currently we have configured 2 test instances using NORECOVERY option with Log Shopping jobs – Backup, Copy and Restore setup to run every hour while Log history of these three jobs shows no error. i.e. Backup executes successfully on 2008R2 instance, Copy and Restore jobs execute fine on 2016.
– safi qadri
2 mins ago
However, when we check the timestamp of data and log files of the configured databases on 2016, it shows the timestamp when this was configured. It seems transaction logs are not being applied. Also, when we try to open the database on 2016 using Restore -> Database, it reports some transaction log missing (because we configured to delete older than 2 days transaction logs and hence these were deleted after 2 days).
– safi qadri
2 mins ago
It seems that at the time of database open on 2016, it actually applies/restores transaction log files. Please confirm! Would you please show whether there is any way it can apply transaction logs while in this UPGRADE setup as explained above and let older than 2 days transaction log files deleted as per scheduled till we actually upgrade to 2016?
– safi qadri
1 min ago
Currently we have configured 2 test instances using NORECOVERY option with Log Shopping jobs – Backup, Copy and Restore setup to run every hour while Log history of these three jobs shows no error. i.e. Backup executes successfully on 2008R2 instance, Copy and Restore jobs execute fine on 2016.
– safi qadri
2 mins ago
Currently we have configured 2 test instances using NORECOVERY option with Log Shopping jobs – Backup, Copy and Restore setup to run every hour while Log history of these three jobs shows no error. i.e. Backup executes successfully on 2008R2 instance, Copy and Restore jobs execute fine on 2016.
– safi qadri
2 mins ago
However, when we check the timestamp of data and log files of the configured databases on 2016, it shows the timestamp when this was configured. It seems transaction logs are not being applied. Also, when we try to open the database on 2016 using Restore -> Database, it reports some transaction log missing (because we configured to delete older than 2 days transaction logs and hence these were deleted after 2 days).
– safi qadri
2 mins ago
However, when we check the timestamp of data and log files of the configured databases on 2016, it shows the timestamp when this was configured. It seems transaction logs are not being applied. Also, when we try to open the database on 2016 using Restore -> Database, it reports some transaction log missing (because we configured to delete older than 2 days transaction logs and hence these were deleted after 2 days).
– safi qadri
2 mins ago
It seems that at the time of database open on 2016, it actually applies/restores transaction log files. Please confirm! Would you please show whether there is any way it can apply transaction logs while in this UPGRADE setup as explained above and let older than 2 days transaction log files deleted as per scheduled till we actually upgrade to 2016?
– safi qadri
1 min ago
It seems that at the time of database open on 2016, it actually applies/restores transaction log files. Please confirm! Would you please show whether there is any way it can apply transaction logs while in this UPGRADE setup as explained above and let older than 2 days transaction log files deleted as per scheduled till we actually upgrade to 2016?
– safi qadri
1 min ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230348%2frestore-job-run-successfully-without-error-but-actually-not-applied-during-log-s%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230348%2frestore-job-run-successfully-without-error-but-actually-not-applied-during-log-s%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Currently we have configured 2 test instances using NORECOVERY option with Log Shopping jobs – Backup, Copy and Restore setup to run every hour while Log history of these three jobs shows no error. i.e. Backup executes successfully on 2008R2 instance, Copy and Restore jobs execute fine on 2016.
– safi qadri
2 mins ago
However, when we check the timestamp of data and log files of the configured databases on 2016, it shows the timestamp when this was configured. It seems transaction logs are not being applied. Also, when we try to open the database on 2016 using Restore -> Database, it reports some transaction log missing (because we configured to delete older than 2 days transaction logs and hence these were deleted after 2 days).
– safi qadri
2 mins ago
It seems that at the time of database open on 2016, it actually applies/restores transaction log files. Please confirm! Would you please show whether there is any way it can apply transaction logs while in this UPGRADE setup as explained above and let older than 2 days transaction log files deleted as per scheduled till we actually upgrade to 2016?
– safi qadri
1 min ago