Mixing
Restore database using a bak file from another computer
I have a SQL Server database on my PC. I backed up my database so now I have a .bak file.
I recently brought a new PC and want to move the database from my old PC to this PC.
I go to restore database & under source click on device. I then have the backup media type as file & then click Add. I browse to where my .bak file is. However when I browse to this directory no files show up which I don't understand why?
Can I not just copy over the backup file from my old PC to my new one? What am I missing?
sql
sql-server database-administration database-restore 
sql-server-2017 edited Jan 1 at 21:15
marc_s
581k13011211268
asked Jan 1 at 19:08
mHelpMemHelpMe
2,078144379
add a comment |
I have a SQL Server database on my PC. I backed up my database so now I have a .bak file.
I recently brought a new PC and want to move the database from my old PC to this PC.
I go to restore database & under source click on device. I then have the backup media type as file & then click Add. I browse to where my .bak file is. However when I browse to this directory no files show up which I don't understand why?
Can I not just copy over the backup file from my old PC to my new one? What am I missing?
sql
sql-server database-administration database-restore sql-server-2017 edited Jan 1 at 21:15
marc_s
581k13011211268
asked Jan 1 at 19:08
mHelpMemHelpMe
2,078144379
do you see it if you change file types to All when you are searching for the .bak file? The default is .bak, .trn, .log. but you can change it to all.
– smoore4
Jan 1 at 20:34
even when changed to all I still can't see the file
– mHelpMe
Jan 1 at 21:21
add a comment |
I have a SQL Server database on my PC. I backed up my database so now I have a .bak file.
I recently brought a new PC and want to move the database from my old PC to this PC.
I go to restore database & under source click on device. I then have the backup media type as file & then click Add. I browse to where my .bak file is. However when I browse to this directory no files show up which I don't understand why?
Can I not just copy over the backup file from my old PC to my new one? What am I missing?
sql
sql-server database-administration database-restore sql-server-2017 edited Jan 1 at 21:15
marc_s
581k13011211268
asked Jan 1 at 19:08
mHelpMemHelpMe
2,078144379
I have a SQL Server database on my PC. I backed up my database so now I have a .bak file.
I recently brought a new PC and want to move the database from my old PC to this PC.
I go to restore database & under source click on device. I then have the backup media type as file & then click Add. I browse to where my .bak file is. However when I browse to this directory no files show up which I don't understand why?
Can I not just copy over the backup file from my old PC to my new one? What am I missing?
sql
sql-server database-administration database-restore sql-server-2017 sql
sql-server database-administration database-restore sql-server-2017 edited Jan 1 at 21:15
marc_s
581k13011211268
asked Jan 1 at 19:08
mHelpMemHelpMe
2,078144379
edited Jan 1 at 21:15
marc_s
581k13011211268
asked Jan 1 at 19:08
mHelpMemHelpMe
2,078144379
edited Jan 1 at 21:15
marc_s
581k13011211268
edited Jan 1 at 21:15
marc_s
581k13011211268
edited Jan 1 at 21:15
marc_s
581k13011211268
581k13011211268
asked Jan 1 at 19:08
mHelpMemHelpMe
2,078144379
asked Jan 1 at 19:08
mHelpMemHelpMe
2,078144379
asked Jan 1 at 19:08
mHelpMemHelpMe
2,078144379
2,078144379
do you see it if you change file types to All when you are searching for the .bak file? The default is .bak, .trn, .log. but you can change it to all.
– smoore4
Jan 1 at 20:34
even when changed to all I still can't see the file
– mHelpMe
Jan 1 at 21:21
add a comment |
do you see it if you change file types to All when you are searching for the .bak file? The default is .bak, .trn, .log. but you can change it to all.
– smoore4
Jan 1 at 20:34
even when changed to all I still can't see the file
– mHelpMe
Jan 1 at 21:21
do you see it if you change file types to All when you are searching for the .bak file? The default is .bak, .trn, .log. but you can change it to all.
– smoore4
Jan 1 at 20:34
do you see it if you change file types to All when you are searching for the .bak file? The default is .bak, .trn, .log. but you can change it to all.
– smoore4
Jan 1 at 20:34
even when changed to all I still can't see the file
– mHelpMe
Jan 1 at 21:21
even when changed to all I still can't see the file
– mHelpMe
Jan 1 at 21:21
add a comment |
1 Answer
1
active
oldest
votes
I do it manually. First, find out where your new server keeps it's database (mdf) and log (ldf) files
SELECT name, physical_name FROM sys.master_files
Then, find out what the logical names of those files are in your backup
restore FILELISTONLY FROM DISK='c:dirfile.bak'
Finally, use combine that info to do the restore:
RESTORE DATABASE DataBaseToCreate
FROM DISK = 'c:dirfile.bak'
WITH REPLACE,
MOVE 'DBLogicalName' TO 'C:DB_DIRDataBaseToCreate.mdf'
MOVE 'LogLogicalName' TO 'C:LOG_DIRDatabaseToCreate.ldf'
answered Jan 1 at 19:41
Ed CallahanEd Callahan
1495
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f53998193%2frestore-database-using-a-bak-file-from-another-computer%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
I do it manually. First, find out where your new server keeps it's database (mdf) and log (ldf) files
SELECT name, physical_name FROM sys.master_files
Then, find out what the logical names of those files are in your backup
restore FILELISTONLY FROM DISK='c:dirfile.bak'
Finally, use combine that info to do the restore:
RESTORE DATABASE DataBaseToCreate
FROM DISK = 'c:dirfile.bak'
WITH REPLACE,
MOVE 'DBLogicalName' TO 'C:DB_DIRDataBaseToCreate.mdf'
MOVE 'LogLogicalName' TO 'C:LOG_DIRDatabaseToCreate.ldf'
answered Jan 1 at 19:41
Ed CallahanEd Callahan
1495
add a comment |
I do it manually. First, find out where your new server keeps it's database (mdf) and log (ldf) files
SELECT name, physical_name FROM sys.master_files
Then, find out what the logical names of those files are in your backup
restore FILELISTONLY FROM DISK='c:dirfile.bak'
Finally, use combine that info to do the restore:
RESTORE DATABASE DataBaseToCreate
FROM DISK = 'c:dirfile.bak'
WITH REPLACE,
MOVE 'DBLogicalName' TO 'C:DB_DIRDataBaseToCreate.mdf'
MOVE 'LogLogicalName' TO 'C:LOG_DIRDatabaseToCreate.ldf'
answered Jan 1 at 19:41
Ed CallahanEd Callahan
1495
add a comment |
I do it manually. First, find out where your new server keeps it's database (mdf) and log (ldf) files
SELECT name, physical_name FROM sys.master_files
Then, find out what the logical names of those files are in your backup
restore FILELISTONLY FROM DISK='c:dirfile.bak'
Finally, use combine that info to do the restore:
RESTORE DATABASE DataBaseToCreate
FROM DISK = 'c:dirfile.bak'
WITH REPLACE,
MOVE 'DBLogicalName' TO 'C:DB_DIRDataBaseToCreate.mdf'
MOVE 'LogLogicalName' TO 'C:LOG_DIRDatabaseToCreate.ldf'
answered Jan 1 at 19:41
Ed CallahanEd Callahan
1495
I do it manually. First, find out where your new server keeps it's database (mdf) and log (ldf) files
SELECT name, physical_name FROM sys.master_files
Then, find out what the logical names of those files are in your backup
restore FILELISTONLY FROM DISK='c:dirfile.bak'
Finally, use combine that info to do the restore:
RESTORE DATABASE DataBaseToCreate
FROM DISK = 'c:dirfile.bak'
WITH REPLACE,
MOVE 'DBLogicalName' TO 'C:DB_DIRDataBaseToCreate.mdf'
MOVE 'LogLogicalName' TO 'C:LOG_DIRDatabaseToCreate.ldf'
answered Jan 1 at 19:41
Ed CallahanEd Callahan
1495
answered Jan 1 at 19:41
Ed CallahanEd Callahan
1495
answered Jan 1 at 19:41
Ed CallahanEd Callahan
1495
answered Jan 1 at 19:41
Ed CallahanEd Callahan
1495
1495
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53998193%2frestore-database-using-a-bak-file-from-another-computer%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
do you see it if you change file types to All when you are searching for the .bak file? The default is .bak, .trn, .log. but you can change it to all.
– smoore4
Jan 1 at 20:34
even when changed to all I still can't see the file
– mHelpMe
Jan 1 at 21:21