|
Home > Archive > MS SQL Server > October 2006 > Re: Unable to create backup file on local pc if db is on remote se
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: Unable to create backup file on local pc if db is on remote se
|
|
| dvarma 2006-10-24, 6:38 pm |
| Thanks for the reply
My computer name - User2
Remote Server - User03
My D: drive is Mapped drive O: on User03
In Enterprise Manager I connect to User03
and in Backup
I give this path
\\user2\D$
I get error "Permission denied" though the login has backup permission on
the db
running xp_cmdshell does show "Access denied"
How do I grant this permission
"Dejan Sarka" wrote:
> Hi!
>
> Do please check how to create backup on a network share. There are plenty of
> articles, for example
> http://searchsqlserver.techtarget.c...
31243,00.html.
>
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www. SolidQualityLearning
.com
> Anything written in this message represents solely the point of view of the
> sender.
> This message does not imply endorsement from Solid Quality Learning, and it
> does not represent the point of view of Solid Quality Learning or any other
> person, company or institution mentioned in this message
>
> "dvarma" <dvarma@discussions.microsoft.com> wrote in message
> news:7747358C-E151-4CD2-AA32- A84E4139DBEE@microso
ft.com...
>
>
>
| |
| Dejan Sarka 2006-10-24, 6:38 pm |
| > running xp_cmdshell does show "Access denied"
>
> How do I grant this permission
You have to grant the NTFS and Share permissions. For both, use Windows
Explorer, right-click on the folder and select Properties. On the Sharing
page you can set up share permissions, on the Security page NTFS
permissions.
--
Dejan Sarka, SQL Server MVP
Mentor, www. SolidQualityLearning
.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
| |
| dvarma 2006-10-24, 6:38 pm |
| The folder is already shared in User2
"Dejan Sarka" wrote:
>
> You have to grant the NTFS and Share permissions. For both, use Windows
> Explorer, right-click on the folder and select Properties. On the Sharing
> page you can set up share permissions, on the Security page NTFS
> permissions.
>
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www. SolidQualityLearning
.com
> Anything written in this message represents solely the point of view of the
> sender.
> This message does not imply endorsement from Solid Quality Learning, and it
> does not represent the point of view of Solid Quality Learning or any other
> person, company or institution mentioned in this message
>
>
>
| |
| Tibor Karaszi 2006-10-24, 6:38 pm |
| Does the service account that the SQL Server service is using have permissions on that share?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"dvarma" <dvarma@discussions.microsoft.com> wrote in message
news:09D55E0E-88EF-4350-99F5- C4ADDBD6BCD5@microso
ft.com...[color=darkred]
> The folder is already shared in User2
>
> "Dejan Sarka" wrote:
>
| |
| dvarma 2006-10-24, 6:38 pm |
| In User03 (remote server) Sql 2000 serviceI have made camsoftadmin (Admin
user) the logon . Anything else I need to do
Do
"Tibor Karaszi" wrote:
> Does the service account that the SQL Server service is using have permissions on that share?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "dvarma" <dvarma@discussions.microsoft.com> wrote in message
> news:09D55E0E-88EF-4350-99F5- C4ADDBD6BCD5@microso
ft.com...
>
>
>
| |
| Tibor Karaszi 2006-10-24, 6:38 pm |
| You need to make sure that the Windows user that SQL Server is using on the remote server have
access and permissions on the share on your local machine.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"dvarma" <dvarma@discussions.microsoft.com> wrote in message
news:0B3FFC14-9166-4010-A0B8- B90A73855B79@microso
ft.com...[color=darkred]
> In User03 (remote server) Sql 2000 serviceI have made camsoftadmin (Admin
> user) the logon . Anything else I need to do
> Do
>
> "Tibor Karaszi" wrote:
>
| |
| dvarma 2006-10-24, 6:38 pm |
| I have already done this
"Tibor Karaszi" wrote:
> You need to make sure that the Windows user that SQL Server is using on the remote server have
> access and permissions on the share on your local machine.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "dvarma" <dvarma@discussions.microsoft.com> wrote in message
> news:0B3FFC14-9166-4010-A0B8- B90A73855B79@microso
ft.com...
>
>
>
| |
| Dejan Sarka 2006-10-24, 6:38 pm |
| I see you are rying to do the backup on the administrative share, i.e. on
the root folder. IIRC the default Windows Server 2003 security policy does
not allow writing to the root. Try to make a subfolder, share it and backup
there.
--
Dejan Sarka, SQL Server MVP
Mentor, www. SolidQualityLearning
.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
"dvarma" <dvarma@discussions.microsoft.com> wrote in message
news:D97D18F5-32ED-4AFC-AEC8- 0F103ACB4189@microso
ft.com...[color=darkred]
>I have already done this
>
> "Tibor Karaszi" wrote:
>
| |
| Tibor Karaszi 2006-10-24, 6:38 pm |
| >I see you are rying to do the backup on the administrative share,
Good catch, Dejan...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Dejan Sarka" < dejan_please_reply_t
o_newsgroups.sarka@avtenta.si> wrote in message
news:Oo6E7qe8GHA.4084@TK2MSFTNGP05.phx.gbl...
>I see you are rying to do the backup on the administrative share, i.e. on the root folder. IIRC the
>default Windows Server 2003 security policy does not allow writing to the root. Try to make a
>subfolder, share it and backup there.
>
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www. SolidQualityLearning
.com
> Anything written in this message represents solely the point of view of the sender.
> This message does not imply endorsement from Solid Quality Learning, and it does not represent the
> point of view of Solid Quality Learning or any other person, company or institution mentioned in
> this message
>
> "dvarma" <dvarma@discussions.microsoft.com> wrote in message
> news:D97D18F5-32ED-4AFC-AEC8- 0F103ACB4189@microso
ft.com...
>
>
| |
|
|
|
|
|