Backup to multiple locations

I currently have a database backing up to a file, every
day a new file is created and anything older than 2 weeks
is deleted. We then use the replace command to copy the
directory to another server.
We are having problems with the deleted file on the SQL
server not being deleted on the other server. Does
anyone know an easy way to do this? Or is it possible to
back up to two locations at once?
Thanks in advance,
Stevesounds like the acct used for SQL services doesn't have permission to delete
fiels on the other servers.
"steve" <anonymous@.discussions.microsoft.com> wrote in message
news:105601c3a248$7bfd2ac0$a001280a@.phx.gbl...
> I currently have a database backing up to a file, every
> day a new file is created and anything older than 2 weeks
> is deleted. We then use the replace command to copy the
> directory to another server.
> We are having problems with the deleted file on the SQL
> server not being deleted on the other server. Does
> anyone know an easy way to do this? Or is it possible to
> back up to two locations at once?
> Thanks in advance,
> Steve|||That is what I originally thought but I am running it as
a domain admin (full control) and am still unable to get
the deleted files to delete from the second server.
Any other ideas?
Steve
>--Original Message--
>sounds like the acct used for SQL services doesn't have
permission to delete
>fiels on the other servers.
>
>"steve" <anonymous@.discussions.microsoft.com> wrote in
message
>news:105601c3a248$7bfd2ac0$a001280a@.phx.gbl...
>> I currently have a database backing up to a file, every
>> day a new file is created and anything older than 2
weeks
>> is deleted. We then use the replace command to copy
the
>> directory to another server.
>> We are having problems with the deleted file on the SQL
>> server not being deleted on the other server. Does
>> anyone know an easy way to do this? Or is it possible
to
>> back up to two locations at once?
>> Thanks in advance,
>> Steve
>
>.|||The permissions may have been the problem afterall. For
some reason the replace command is now working and the
deleted files are being removed. It is very strange.
Thanks for your help.
Steve
>--Original Message--
>sounds like the acct used for SQL services doesn't have
permission to delete
>fiels on the other servers.
>
>"steve" <anonymous@.discussions.microsoft.com> wrote in
message
>news:105601c3a248$7bfd2ac0$a001280a@.phx.gbl...
>> I currently have a database backing up to a file, every
>> day a new file is created and anything older than 2
weeks
>> is deleted. We then use the replace command to copy
the
>> directory to another server.
>> We are having problems with the deleted file on the SQL
>> server not being deleted on the other server. Does
>> anyone know an easy way to do this? Or is it possible
to
>> back up to two locations at once?
>> Thanks in advance,
>> Steve
>
>.
>