|
Home > Archive > MS SQL Server > April 2006 > xp_unc_to_drive
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]
|
|
|
|
Can anyone tell me how to use this extended stored procedure, what
parameters does it take and what does it return? I know that it is an
undocumented stored procedure, but I am guessing there must be someone out
there who has an idea of what this xp does.
I was trying to convert a mapped drive to UNC path for db backups in SQL
Server 2000 (SP4) and came across this xp during my search, hence the
curiosity.
Thanks in anticipation.
| |
| Edgardo Valdez, MCSD, MCDBA 2006-04-03, 1:23 pm |
| If you are trying to use a UNC path to store your DB backups, as long as the
server is able to see the UNC path (based on permissions), you should be able
to access it directly from the backup job. I do it all the time to save the
backups to another file server via UNC
"KMP" wrote:
>
> Can anyone tell me how to use this extended stored procedure, what
> parameters does it take and what does it return? I know that it is an
> undocumented stored procedure, but I am guessing there must be someone out
> there who has an idea of what this xp does.
>
> I was trying to convert a mapped drive to UNC path for db backups in SQL
> Server 2000 (SP4) and came across this xp during my search, hence the
> curiosity.
>
> Thanks in anticipation.
| |
|
|
I am storing the mapped drive (value) into a db table through a GUI app. I
would like to convert this mapped drive into the appropriate UNC path value
before it gets stored in the table. I found a windows API which does this
(MPR.dll). I am curious to know if there is any extended sp which does this.
Once I have the UNC path in the table, the job which creates the backup can
backup the db to the UNC path. I am aware of the permissions setting and
using domain account to start SQL Server and SQL Agent. Thanks.
"Edgardo Valdez, MCSD, MCDBA" wrote:
[color=darkred]
> If you are trying to use a UNC path to store your DB backups, as long as the
> server is able to see the UNC path (based on permissions), you should be able
> to access it directly from the backup job. I do it all the time to save the
> backups to another file server via UNC
>
> "KMP" wrote:
>
|
|
|
|
|