Database Merging / Re-integrationHow to restore database using old full backup and current log fileHelp with...
How to move the player while also allowing forces to affect it
Denied boarding due to overcrowding, Sparpreis ticket. What are my rights?
Why was the "bread communication" in the arena of Catching Fire left out in the movie?
Eliminate empty elements from a list with a specific pattern
Can the Produce Flame cantrip be used to grapple, or as an unarmed strike, in the right circumstances?
Hosting Wordpress in a EC2 Load Balanced Instance
How did the USSR manage to innovate in an environment characterized by government censorship and high bureaucracy?
Information to fellow intern about hiring?
Are cabin dividers used to "hide" the flex of the airplane?
Is every set a filtered colimit of finite sets?
Could Giant Ground Sloths have been a good pack animal for the ancient Mayans?
Domain expired, GoDaddy holds it and is asking more money
LWC and complex parameters
Are objects structures and/or vice versa?
What do you call something that goes against the spirit of the law, but is legal when interpreting the law to the letter?
Crop image to path created in TikZ?
What does 'script /dev/null' do?
Can I find out the caloric content of bread by dehydrating it?
Does the average primeness of natural numbers tend to zero?
Why airport relocation isn't done gradually?
aging parents with no investments
Landlord wants to switch my lease to a "Land contract" to "get back at the city"
New order #4: World
What happens when a metallic dragon and a chromatic dragon mate?
Database Merging / Re-integration
How to restore database using old full backup and current log fileHelp with best practice of merging databasesInformation on a Database that was restored with NO RECOVERY“Scan interface error” when connecting to a DB2 database restored on a different serverBACKUP Detected Corruption in the database logPREEMPTIVE_OS_WRITEFILEGATHER wait on database RESTORE with IFI onUnShrunk SQL Server database restore which is larger than available disk spaceSQL Server database snapshots for integration testingSQL Server Partial Only Database MoveHow to recover if SQL Server is stuck in Restoring state?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I am a SQL Server DBA. I recently had the misfortune of losing a database due to drive failure. I was able to restore the data but for whatever reason, it stopped at a certain time and not all of the data was restored. I restored the database again to a test server only to find and restore ALL of the data but the problem is, I now have to get the rest of the data that did not restore on to the server where it is supposed to be. Can that be done? Given all the primary key contraints and uniqueness of those keys involved, imagine we will have to renumber some of the rows that were affected because those keys have been reused once the database came back up and was operating.
sql-server restore
asked 1 hour ago
Corey CarterCorey Carter
61
New contributor
Corey Carter is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I am a SQL Server DBA. I recently had the misfortune of losing a database due to drive failure. I was able to restore the data but for whatever reason, it stopped at a certain time and not all of the data was restored. I restored the database again to a test server only to find and restore ALL of the data but the problem is, I now have to get the rest of the data that did not restore on to the server where it is supposed to be. Can that be done? Given all the primary key contraints and uniqueness of those keys involved, imagine we will have to renumber some of the rows that were affected because those keys have been reused once the database came back up and was operating.
sql-server restore
asked 1 hour ago
Corey CarterCorey Carter
61
New contributor
Corey Carter is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I am a SQL Server DBA. I recently had the misfortune of losing a database due to drive failure. I was able to restore the data but for whatever reason, it stopped at a certain time and not all of the data was restored. I restored the database again to a test server only to find and restore ALL of the data but the problem is, I now have to get the rest of the data that did not restore on to the server where it is supposed to be. Can that be done? Given all the primary key contraints and uniqueness of those keys involved, imagine we will have to renumber some of the rows that were affected because those keys have been reused once the database came back up and was operating.
sql-server restore
asked 1 hour ago
Corey CarterCorey Carter
61
New contributor
Corey Carter is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I am a SQL Server DBA. I recently had the misfortune of losing a database due to drive failure. I was able to restore the data but for whatever reason, it stopped at a certain time and not all of the data was restored. I restored the database again to a test server only to find and restore ALL of the data but the problem is, I now have to get the rest of the data that did not restore on to the server where it is supposed to be. Can that be done? Given all the primary key contraints and uniqueness of those keys involved, imagine we will have to renumber some of the rows that were affected because those keys have been reused once the database came back up and was operating.
sql-server restore
sql-server restore
asked 1 hour ago
Corey CarterCorey Carter
61
New contributor
Corey Carter is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 1 hour ago
Corey CarterCorey Carter
61
New contributor
Corey Carter is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 1 hour ago
Corey CarterCorey Carter
61
New contributor
Corey Carter is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 1 hour ago
Corey CarterCorey Carter
61
asked 1 hour ago
Corey CarterCorey Carter
61
61
New contributor
Corey Carter is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Corey Carter is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Corey Carter is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
So you attempted to restore the database in production but it didn’t finish? Can you elaborate more, did it finish completely, we’re there any error messages, etc.
Then you were able to successfully restore the database to a test server?
Have you verified if the backup file is good? See this article if not
https://www.mssqltips.com/sqlservertutorial/113/checking-to-make-sure-a-sql-server-backup-is-useable/
You may want to check that and if ok try to restore in production again.
answered 27 mins ago
kevinnwhatkevinnwhat
282
add a comment |
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
});
}
});
Corey Carter is a new contributor. Be nice, and check out our Code of Conduct.
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%2f234251%2fdatabase-merging-re-integration%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
So you attempted to restore the database in production but it didn’t finish? Can you elaborate more, did it finish completely, we’re there any error messages, etc.
Then you were able to successfully restore the database to a test server?
Have you verified if the backup file is good? See this article if not
https://www.mssqltips.com/sqlservertutorial/113/checking-to-make-sure-a-sql-server-backup-is-useable/
You may want to check that and if ok try to restore in production again.
answered 27 mins ago
kevinnwhatkevinnwhat
282
add a comment |
So you attempted to restore the database in production but it didn’t finish? Can you elaborate more, did it finish completely, we’re there any error messages, etc.
Then you were able to successfully restore the database to a test server?
Have you verified if the backup file is good? See this article if not
https://www.mssqltips.com/sqlservertutorial/113/checking-to-make-sure-a-sql-server-backup-is-useable/
You may want to check that and if ok try to restore in production again.
answered 27 mins ago
kevinnwhatkevinnwhat
282
add a comment |
So you attempted to restore the database in production but it didn’t finish? Can you elaborate more, did it finish completely, we’re there any error messages, etc.
Then you were able to successfully restore the database to a test server?
Have you verified if the backup file is good? See this article if not
https://www.mssqltips.com/sqlservertutorial/113/checking-to-make-sure-a-sql-server-backup-is-useable/
You may want to check that and if ok try to restore in production again.
answered 27 mins ago
kevinnwhatkevinnwhat
282
So you attempted to restore the database in production but it didn’t finish? Can you elaborate more, did it finish completely, we’re there any error messages, etc.
Then you were able to successfully restore the database to a test server?
Have you verified if the backup file is good? See this article if not
https://www.mssqltips.com/sqlservertutorial/113/checking-to-make-sure-a-sql-server-backup-is-useable/
You may want to check that and if ok try to restore in production again.
answered 27 mins ago
kevinnwhatkevinnwhat
282
answered 27 mins ago
kevinnwhatkevinnwhat
282
answered 27 mins ago
kevinnwhatkevinnwhat
282
answered 27 mins ago
kevinnwhatkevinnwhat
282
282
add a comment |
add a comment |
Corey Carter is a new contributor. Be nice, and check out our Code of Conduct.
Corey Carter is a new contributor. Be nice, and check out our Code of Conduct.
Corey Carter is a new contributor. Be nice, and check out our Code of Conduct.
Corey Carter is a new contributor. Be nice, and check out our Code of Conduct.
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%2f234251%2fdatabase-merging-re-integration%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
