Local Computer drives are not visible when creating backup through wizardSQL Server 2000: Database copy wizard - Claims files already exist (they don't) or there is not enough disk space (there is)When successfully configured SQL Server for database mirroring, got an error saying it's not configured for database mirroringRestoring SQL Server backup to SQL Azure on SQL Management StudioMS SQL Start Mirroring Error
Explain why a line can never intersect a plane in exactly two points.
Improve appearance of the table in Latex
What type of tests you should do first?
Is there a name for the trope when there is a moments dialogue when someone pauses just before they leave the room?
How to remove this inheritance-related code smell?
80s or 90s Fantasy novel, part of series. Castle talks to wizard, 2 headed dragon fights itself
Why does this compile? Returning nullptr as std::string
Why is it easier to balance a non-moving bike standing up than sitting down?
How did Gollum enter Moria?
Why is "Congress shall have power to enforce this article by appropriate legislation" necessary?
Why isn't my calculation that we should be able to see the sun well beyond the observable universe valid?
Mathematically modelling RC circuit with a linear input
What is the highest voltage from the power supply a Raspberry Pi 3 B can handle without getting damaged?
Helping ease my back pain by studying 13 hours everyday , even weekends
Can Hunter's Mark be moved after Silence has been cast on a character?
Rejecting an offer after accepting it just 10 days from date of joining
Is it possible to transpose samples (in cents) from minor to major?
"Correct me if I'm wrong"
Definition of 'vrit'
Should I include an appendix for inessential, yet related worldbuilding to my story?
How did the Vostok ejection seat safely eject an astronaut from a sealed space capsule?
What does it cost to buy a tavern?
Are there any individual aliens that have gained superpowers in the Marvel universe?
Should the party get XP for a monster they never attacked?
Local Computer drives are not visible when creating backup through wizard
SQL Server 2000: Database copy wizard - Claims files already exist (they don't) or there is not enough disk space (there is)When successfully configured SQL Server for database mirroring, got an error saying it's not configured for database mirroringRestoring SQL Server backup to SQL Azure on SQL Management StudioMS SQL Start Mirroring Error
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
When I connect to a database on a remote server through SSMS running on my own computer and I follow the backup wizard for a database, none of my local computer drives are listed. All I can see are drives on the remote server and I can't get access to them since I do not have enough permissions.
It seems weird, why I can't see my own computer drive volumes when creating a backup file?
Here's what I do:
On Object Explorer, right click on database then click on Tasks > Backup, Add > ...
Part of error message: Can not access the specified path on server.
sql-server ssms
edited Jun 3 at 10:13
Daniel K
330111
asked Jun 3 at 5:58
Mohammad lm71Mohammad lm71
1064
add a comment |
When I connect to a database on a remote server through SSMS running on my own computer and I follow the backup wizard for a database, none of my local computer drives are listed. All I can see are drives on the remote server and I can't get access to them since I do not have enough permissions.
It seems weird, why I can't see my own computer drive volumes when creating a backup file?
Here's what I do:
On Object Explorer, right click on database then click on Tasks > Backup, Add > ...
Part of error message: Can not access the specified path on server.
sql-server ssms
edited Jun 3 at 10:13
Daniel K
330111
asked Jun 3 at 5:58
Mohammad lm71Mohammad lm71
1064
add a comment |
When I connect to a database on a remote server through SSMS running on my own computer and I follow the backup wizard for a database, none of my local computer drives are listed. All I can see are drives on the remote server and I can't get access to them since I do not have enough permissions.
It seems weird, why I can't see my own computer drive volumes when creating a backup file?
Here's what I do:
On Object Explorer, right click on database then click on Tasks > Backup, Add > ...
Part of error message: Can not access the specified path on server.
sql-server ssms
edited Jun 3 at 10:13
Daniel K
330111
asked Jun 3 at 5:58
Mohammad lm71Mohammad lm71
1064
When I connect to a database on a remote server through SSMS running on my own computer and I follow the backup wizard for a database, none of my local computer drives are listed. All I can see are drives on the remote server and I can't get access to them since I do not have enough permissions.
It seems weird, why I can't see my own computer drive volumes when creating a backup file?
Here's what I do:
On Object Explorer, right click on database then click on Tasks > Backup, Add > ...
Part of error message: Can not access the specified path on server.
sql-server ssms
sql-server ssms
edited Jun 3 at 10:13
Daniel K
330111
asked Jun 3 at 5:58
Mohammad lm71Mohammad lm71
1064
edited Jun 3 at 10:13
Daniel K
330111
asked Jun 3 at 5:58
Mohammad lm71Mohammad lm71
1064
edited Jun 3 at 10:13
Daniel K
330111
edited Jun 3 at 10:13
Daniel K
330111
edited Jun 3 at 10:13
Daniel K
330111
330111
asked Jun 3 at 5:58
Mohammad lm71Mohammad lm71
1064
asked Jun 3 at 5:58
Mohammad lm71Mohammad lm71
1064
asked Jun 3 at 5:58
Mohammad lm71Mohammad lm71
1064
1064
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
This behaviour is expected.
SQL Server runs on the remote server, in a service account so it cannot not see your own volumes. Why would SQL Server have any special rights to see your local computer?.
You have to create a file share on your local computer, assign appropriate permissions and then you CAN use UNC format (computernamesharename) to use that local file share.
edited Jun 3 at 10:34
Daniel K
330111
answered Jun 3 at 7:00
TomTomTomTom
46.2k642120
SQL Server is running on my computer, it's accessing to remote SQL server, so SSMS knows my computer drives, it'sOBVIOUSthat what you said is not that obvious !!!
– Mohammad lm71
Jun 3 at 7:21
1
No, it is not. Let me quote your first sentence that you obviously did not read yourself: "I connect to a database on a remote server". Remote server != local computer. SSMS != SQL Server. SSMS locally can see them, but it sends STRINGS to the server, and the server has diffrerent ideas what C: means than your SSMS on your computer.
– TomTom
Jun 3 at 7:30
Youobviouslydidn't pay attention to the wordthroughinI connect ... through SSMS running on my own computer. Never mind, It sucks when there are tons of obvious phrases with no feasible solution.
– Mohammad lm71
Jun 3 at 9:38
SSMS running local is irrelevant. Backups are - as documentation states - run WITHOUT ssms - all SSMS does is send the command string to the server. As such, you can run SSMS where you want, what matters is that the server can reach the location through the path you enter into SSMS (because that path gets sent to the server).
– TomTom
Jun 3 at 9:39
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
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%2fserverfault.com%2fquestions%2f969888%2flocal-computer-drives-are-not-visible-when-creating-backup-through-wizard%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
This behaviour is expected.
SQL Server runs on the remote server, in a service account so it cannot not see your own volumes. Why would SQL Server have any special rights to see your local computer?.
You have to create a file share on your local computer, assign appropriate permissions and then you CAN use UNC format (computernamesharename) to use that local file share.
edited Jun 3 at 10:34
Daniel K
330111
answered Jun 3 at 7:00
TomTomTomTom
46.2k642120
SQL Server is running on my computer, it's accessing to remote SQL server, so SSMS knows my computer drives, it'sOBVIOUSthat what you said is not that obvious !!!
– Mohammad lm71
Jun 3 at 7:21
1
No, it is not. Let me quote your first sentence that you obviously did not read yourself: "I connect to a database on a remote server". Remote server != local computer. SSMS != SQL Server. SSMS locally can see them, but it sends STRINGS to the server, and the server has diffrerent ideas what C: means than your SSMS on your computer.
– TomTom
Jun 3 at 7:30
Youobviouslydidn't pay attention to the wordthroughinI connect ... through SSMS running on my own computer. Never mind, It sucks when there are tons of obvious phrases with no feasible solution.
– Mohammad lm71
Jun 3 at 9:38
SSMS running local is irrelevant. Backups are - as documentation states - run WITHOUT ssms - all SSMS does is send the command string to the server. As such, you can run SSMS where you want, what matters is that the server can reach the location through the path you enter into SSMS (because that path gets sent to the server).
– TomTom
Jun 3 at 9:39
add a comment |
This behaviour is expected.
SQL Server runs on the remote server, in a service account so it cannot not see your own volumes. Why would SQL Server have any special rights to see your local computer?.
You have to create a file share on your local computer, assign appropriate permissions and then you CAN use UNC format (computernamesharename) to use that local file share.
edited Jun 3 at 10:34
Daniel K
330111
answered Jun 3 at 7:00
TomTomTomTom
46.2k642120
SQL Server is running on my computer, it's accessing to remote SQL server, so SSMS knows my computer drives, it'sOBVIOUSthat what you said is not that obvious !!!
– Mohammad lm71
Jun 3 at 7:21
1
No, it is not. Let me quote your first sentence that you obviously did not read yourself: "I connect to a database on a remote server". Remote server != local computer. SSMS != SQL Server. SSMS locally can see them, but it sends STRINGS to the server, and the server has diffrerent ideas what C: means than your SSMS on your computer.
– TomTom
Jun 3 at 7:30
Youobviouslydidn't pay attention to the wordthroughinI connect ... through SSMS running on my own computer. Never mind, It sucks when there are tons of obvious phrases with no feasible solution.
– Mohammad lm71
Jun 3 at 9:38
SSMS running local is irrelevant. Backups are - as documentation states - run WITHOUT ssms - all SSMS does is send the command string to the server. As such, you can run SSMS where you want, what matters is that the server can reach the location through the path you enter into SSMS (because that path gets sent to the server).
– TomTom
Jun 3 at 9:39
add a comment |
This behaviour is expected.
SQL Server runs on the remote server, in a service account so it cannot not see your own volumes. Why would SQL Server have any special rights to see your local computer?.
You have to create a file share on your local computer, assign appropriate permissions and then you CAN use UNC format (computernamesharename) to use that local file share.
edited Jun 3 at 10:34
Daniel K
330111
answered Jun 3 at 7:00
TomTomTomTom
46.2k642120
This behaviour is expected.
SQL Server runs on the remote server, in a service account so it cannot not see your own volumes. Why would SQL Server have any special rights to see your local computer?.
You have to create a file share on your local computer, assign appropriate permissions and then you CAN use UNC format (computernamesharename) to use that local file share.
edited Jun 3 at 10:34
Daniel K
330111
answered Jun 3 at 7:00
TomTomTomTom
46.2k642120
edited Jun 3 at 10:34
Daniel K
330111
edited Jun 3 at 10:34
Daniel K
330111
edited Jun 3 at 10:34
Daniel K
330111
330111
answered Jun 3 at 7:00
TomTomTomTom
46.2k642120
answered Jun 3 at 7:00
TomTomTomTom
46.2k642120
answered Jun 3 at 7:00
TomTomTomTom
46.2k642120
46.2k642120
SQL Server is running on my computer, it's accessing to remote SQL server, so SSMS knows my computer drives, it'sOBVIOUSthat what you said is not that obvious !!!
– Mohammad lm71
Jun 3 at 7:21
1
No, it is not. Let me quote your first sentence that you obviously did not read yourself: "I connect to a database on a remote server". Remote server != local computer. SSMS != SQL Server. SSMS locally can see them, but it sends STRINGS to the server, and the server has diffrerent ideas what C: means than your SSMS on your computer.
– TomTom
Jun 3 at 7:30
Youobviouslydidn't pay attention to the wordthroughinI connect ... through SSMS running on my own computer. Never mind, It sucks when there are tons of obvious phrases with no feasible solution.
– Mohammad lm71
Jun 3 at 9:38
SSMS running local is irrelevant. Backups are - as documentation states - run WITHOUT ssms - all SSMS does is send the command string to the server. As such, you can run SSMS where you want, what matters is that the server can reach the location through the path you enter into SSMS (because that path gets sent to the server).
– TomTom
Jun 3 at 9:39
add a comment |
SQL Server is running on my computer, it's accessing to remote SQL server, so SSMS knows my computer drives, it'sOBVIOUSthat what you said is not that obvious !!!
– Mohammad lm71
Jun 3 at 7:21
1
No, it is not. Let me quote your first sentence that you obviously did not read yourself: "I connect to a database on a remote server". Remote server != local computer. SSMS != SQL Server. SSMS locally can see them, but it sends STRINGS to the server, and the server has diffrerent ideas what C: means than your SSMS on your computer.
– TomTom
Jun 3 at 7:30
Youobviouslydidn't pay attention to the wordthroughinI connect ... through SSMS running on my own computer. Never mind, It sucks when there are tons of obvious phrases with no feasible solution.
– Mohammad lm71
Jun 3 at 9:38
SSMS running local is irrelevant. Backups are - as documentation states - run WITHOUT ssms - all SSMS does is send the command string to the server. As such, you can run SSMS where you want, what matters is that the server can reach the location through the path you enter into SSMS (because that path gets sent to the server).
– TomTom
Jun 3 at 9:39
SQL Server is running on my computer, it's accessing to remote SQL server, so SSMS knows my computer drives, it's
OBVIOUS that what you said is not that obvious !!!– Mohammad lm71
Jun 3 at 7:21
SQL Server is running on my computer, it's accessing to remote SQL server, so SSMS knows my computer drives, it's
OBVIOUS that what you said is not that obvious !!!– Mohammad lm71
Jun 3 at 7:21
1
1
No, it is not. Let me quote your first sentence that you obviously did not read yourself: "I connect to a database on a remote server". Remote server != local computer. SSMS != SQL Server. SSMS locally can see them, but it sends STRINGS to the server, and the server has diffrerent ideas what C: means than your SSMS on your computer.
– TomTom
Jun 3 at 7:30
No, it is not. Let me quote your first sentence that you obviously did not read yourself: "I connect to a database on a remote server". Remote server != local computer. SSMS != SQL Server. SSMS locally can see them, but it sends STRINGS to the server, and the server has diffrerent ideas what C: means than your SSMS on your computer.
– TomTom
Jun 3 at 7:30
You
obviously didn't pay attention to the word through in I connect ... through SSMS running on my own computer. Never mind, It sucks when there are tons of obvious phrases with no feasible solution.– Mohammad lm71
Jun 3 at 9:38
You
obviously didn't pay attention to the word through in I connect ... through SSMS running on my own computer. Never mind, It sucks when there are tons of obvious phrases with no feasible solution.– Mohammad lm71
Jun 3 at 9:38
SSMS running local is irrelevant. Backups are - as documentation states - run WITHOUT ssms - all SSMS does is send the command string to the server. As such, you can run SSMS where you want, what matters is that the server can reach the location through the path you enter into SSMS (because that path gets sent to the server).
– TomTom
Jun 3 at 9:39
SSMS running local is irrelevant. Backups are - as documentation states - run WITHOUT ssms - all SSMS does is send the command string to the server. As such, you can run SSMS where you want, what matters is that the server can reach the location through the path you enter into SSMS (because that path gets sent to the server).
– TomTom
Jun 3 at 9:39
add a comment |
Thanks for contributing an answer to Server Fault!
- 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%2fserverfault.com%2fquestions%2f969888%2flocal-computer-drives-are-not-visible-when-creating-backup-through-wizard%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
