|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > Deleting physical backupfile
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 |
Deleting physical backupfile
|
|
|
| Hi all!
I have the administrator rights of an SQL-server. I dont
have the administrating rigths on the Windows-Server where
the sql-server is installed. Is there a way to delete a
physical backup file for me, or do I have to ask the
administrator of the Windows-server to take care of it?
| |
| Dejan Sarka 2002-10-05, 9:13 pm |
| Hi!
If you don't use Kerberos and security delegation and impersonation, then
you can use xp_mdshell from Query Analyzer. Then SQL Server will use it's
own account for Windows authentication, which is usually in the local
Administrators group, for members of the sysadmin role.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"rulle" <rustana@hotmail.com> wrote in message
news:605801c262cf$88ae6cc0$3ae
f2ecf@TKMSFTNGXA09...
> Hi all!
>
> I have the administrator rights of an SQL-server. I dont
> have the administrating rigths on the Windows-Server where
> the sql-server is installed. Is there a way to delete a
> physical backup file for me, or do I have to ask the
> administrator of the Windows-server to take care of it?
| |
|
| Thanks for your answer.
I have to admit that it's a bit cryptic to me. The
xp_mdshell isn't recognised by the query analyser, and I
didn't find any information of the stored procedure in
help. I guess I have to registrer it but I don't know
where the Dll is located, is there a standard catalogue
for the dll?
In sum confused on a higher level...
/Rulle
>-----Original Message-----
>Hi!
>
>If you don't use Kerberos and security delegation and
impersonation, then
>you can use xp_mdshell from Query Analyzer. Then SQL
Server will use it's
>own account for Windows authentication, which is usually
in the local
>Administrators group, for members of the sysadmin role.
>
>--
>Dejan Sarka, SQL Server MVP
>FAQ from Neil & others at: http://www.sqlserverfaq.com
>Please reply only to the newsgroups.
>PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>"rulle" <rustana@hotmail.com> wrote in message
> news:605801c262cf$88ae6cc0$3ae
f2ecf@TKMSFTNGXA09...
>> Hi all!
>>
>> I have the administrator rights of an SQL-server. I dont
>> have the administrating rigths on the Windows-Server
where
>> the sql-server is installed. Is there a way to delete a
>> physical backup file for me, or do I have to ask the
>> administrator of the Windows-server to take care of it?
>
>
>.
>
| |
| Dejan Sarka 2002-10-05, 9:13 pm |
| > I have to admit that it's a bit cryptic to me. The
> xp_mdshell isn't recognised by the query analyser, and I
> didn't find any information of the stored procedure in
> help. I guess I have to registrer it but I don't know
> where the Dll is located, is there a standard catalogue
> for the dll?
Hey, sorry, a typo, should be
xp_cmdshell
Do please look for syntax & examples in Books OnLine.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
| |
|
| Thanks!
>-----Original Message-----
>> I have to admit that it's a bit cryptic to me. The
>> xp_mdshell isn't recognised by the query analyser, and I
>> didn't find any information of the stored procedure in
>> help. I guess I have to registrer it but I don't know
>> where the Dll is located, is there a standard catalogue
>> for the dll?
>
>Hey, sorry, a typo, should be
>
>xp_cmdshell
>
>Do please look for syntax & examples in Books OnLine.
>
>--
>Dejan Sarka, SQL Server MVP
>FAQ from Neil & others at: http://www.sqlserverfaq.com
>Please reply only to the newsgroups.
>PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>
>.
>
|
|
|
|
|