Dear All,
We are running Standard Edition 2000 SP3a on a 2003 Server.
We would like to backup onto the disk of a different 2003
Server.
However under the "Use this directory" of the Database
Maintenance Plan, it does not give the share directory we
set up, and typing the location i.e. \\OtherServer\Backups
results in an error.
All accounts we have tried are domain accounts, and they
have access to the directory.
Can anyone tell me what I'm missing ?
Thanks
PeterGive this a try in Query Analyser :-
BACKUP DATABASE pubs to DISK='\\server01\share\backupdir\backup.dmp'
--
HTH
Ryan Waight, MCDBA, MCSE
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:196c01c426ec$5fa7b420$a601280a@.phx.gbl...
> Dear All,
> We are running Standard Edition 2000 SP3a on a 2003 Server.
> We would like to backup onto the disk of a different 2003
> Server.
> However under the "Use this directory" of the Database
> Maintenance Plan, it does not give the share directory we
> set up, and typing the location i.e. \\OtherServer\Backups
> results in an error.
> All accounts we have tried are domain accounts, and they
> have access to the directory.
> Can anyone tell me what I'm missing ?
> Thanks
> Peter|||Thanks for your reply.
However we are trying to do this from the Database
Maintenance Plan, any pointers ?
Thanks
Peter
>--Original Message--
>Give this a try in Query Analyser :-
>BACKUP DATABASE pubs to DISK='\\server01
\share\backupdir\backup.dmp'
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"Peter" <anonymous@.discussions.microsoft.com> wrote in
message
>news:196c01c426ec$5fa7b420$a601280a@.phx.gbl...
>> Dear All,
>> We are running Standard Edition 2000 SP3a on a 2003
Server.
>> We would like to backup onto the disk of a different
2003
>> Server.
>> However under the "Use this directory" of the Database
>> Maintenance Plan, it does not give the share directory
we
>> set up, and typing the location i.e.
\\OtherServer\Backups
>> results in an error.
>> All accounts we have tried are domain accounts, and they
>> have access to the directory.
>> Can anyone tell me what I'm missing ?
>> Thanks
>> Peter
>
>.
>|||Check that if the account that runs the SQL Server
Services has access to the computer you are trying to
backup to..........
>--Original Message--
>Thanks for your reply.
>However we are trying to do this from the Database
>Maintenance Plan, any pointers ?
>Thanks
>Peter
>
>>--Original Message--
>>Give this a try in Query Analyser :-
>>BACKUP DATABASE pubs to DISK='\\server01
>\share\backupdir\backup.dmp'
>>--
>>HTH
>>Ryan Waight, MCDBA, MCSE
>>"Peter" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:196c01c426ec$5fa7b420$a601280a@.phx.gbl...
>> Dear All,
>> We are running Standard Edition 2000 SP3a on a 2003
>Server.
>> We would like to backup onto the disk of a different
>2003
>> Server.
>> However under the "Use this directory" of the Database
>> Maintenance Plan, it does not give the share directory
>we
>> set up, and typing the location i.e.
>\\OtherServer\Backups
>> results in an error.
>> All accounts we have tried are domain accounts, and
they
>> have access to the directory.
>> Can anyone tell me what I'm missing ?
>> Thanks
>> Peter
>>
>>.
>.
>|||Thanks it does.
It is not a problem with the account, but seems to be a
problem with the Database Maintenance Plan.
thanks
Peter
>--Original Message--
>Check that if the account that runs the SQL Server
>Services has access to the computer you are trying to
>backup to..........
>
>>--Original Message--
>>Thanks for your reply.
>>However we are trying to do this from the Database
>>Maintenance Plan, any pointers ?
>>Thanks
>>Peter
>>
>>--Original Message--
>>Give this a try in Query Analyser :-
>>BACKUP DATABASE pubs to DISK='\\server01
>>\share\backupdir\backup.dmp'
>>--
>>HTH
>>Ryan Waight, MCDBA, MCSE
>>"Peter" <anonymous@.discussions.microsoft.com> wrote in
>>message
>>news:196c01c426ec$5fa7b420$a601280a@.phx.gbl...
>> Dear All,
>> We are running Standard Edition 2000 SP3a on a 2003
>>Server.
>> We would like to backup onto the disk of a different
>>2003
>> Server.
>> However under the "Use this directory" of the Database
>> Maintenance Plan, it does not give the share
directory
>>we
>> set up, and typing the location i.e.
>>\\OtherServer\Backups
>> results in an error.
>> All accounts we have tried are domain accounts, and
>they
>> have access to the directory.
>> Can anyone tell me what I'm missing ?
>> Thanks
>> Peter
>>
>>.
>>.
>.
>|||You never did say what exactly the error is that you are
getting and that makes a difference but...backing up across
the network isn't necessarily the best idea. You may want to
backup to a local drive and then copy the backup to whatever
location you want to keep these on the network.
-Sue
On Tue, 20 Apr 2004 09:16:53 -0700, "Peter"
<anonymous@.discussions.microsoft.com> wrote:
>Thanks it does.
>It is not a problem with the account, but seems to be a
>problem with the Database Maintenance Plan.
>thanks
>Peter
>
>>--Original Message--
>>Check that if the account that runs the SQL Server
>>Services has access to the computer you are trying to
>>backup to..........
>>
>>--Original Message--
>>Thanks for your reply.
>>However we are trying to do this from the Database
>>Maintenance Plan, any pointers ?
>>Thanks
>>Peter
>>
>>--Original Message--
>>Give this a try in Query Analyser :-
>>BACKUP DATABASE pubs to DISK='\\server01
>>\share\backupdir\backup.dmp'
>>--
>>HTH
>>Ryan Waight, MCDBA, MCSE
>>"Peter" <anonymous@.discussions.microsoft.com> wrote in
>>message
>>news:196c01c426ec$5fa7b420$a601280a@.phx.gbl...
>> Dear All,
>> We are running Standard Edition 2000 SP3a on a 2003
>>Server.
>> We would like to backup onto the disk of a different
>>2003
>> Server.
>> However under the "Use this directory" of the Database
>> Maintenance Plan, it does not give the share
>directory
>>we
>> set up, and typing the location i.e.
>>\\OtherServer\Backups
>> results in an error.
>> All accounts we have tried are domain accounts, and
>>they
>> have access to the directory.
>> Can anyone tell me what I'm missing ?
>> Thanks
>> Peter
>>
>>.
>>.
>>.|||Thanks for all your help, it seems that you cannot do it
from the database maintence plan.
Sue the error was 'Directory was not found', and yes the
directory was there and we do have access rights to the
directory. It seems that the database maintenance plan
will only allow you to save to the server SQL is running
on.
Peter
>--Original Message--
>You never did say what exactly the error is that you are
>getting and that makes a difference but...backing up
across
>the network isn't necessarily the best idea. You may want
to
>backup to a local drive and then copy the backup to
whatever
>location you want to keep these on the network.
>-Sue
>On Tue, 20 Apr 2004 09:16:53 -0700, "Peter"
><anonymous@.discussions.microsoft.com> wrote:
>>Thanks it does.
>>It is not a problem with the account, but seems to be a
>>problem with the Database Maintenance Plan.
>>thanks
>>Peter
>>
>>--Original Message--
>>Check that if the account that runs the SQL Server
>>Services has access to the computer you are trying to
>>backup to..........
>>
>>--Original Message--
>>Thanks for your reply.
>>However we are trying to do this from the Database
>>Maintenance Plan, any pointers ?
>>Thanks
>>Peter
>>
>>--Original Message--
>>Give this a try in Query Analyser :-
>>BACKUP DATABASE pubs to DISK='\\server01
>>\share\backupdir\backup.dmp'
>>--
>>HTH
>>Ryan Waight, MCDBA, MCSE
>>"Peter" <anonymous@.discussions.microsoft.com> wrote
in
>>message
>>news:196c01c426ec$5fa7b420$a601280a@.phx.gbl...
>> Dear All,
>> We are running Standard Edition 2000 SP3a on a 2003
>>Server.
>> We would like to backup onto the disk of a
different
>>2003
>> Server.
>> However under the "Use this directory" of the
Database
>> Maintenance Plan, it does not give the share
>>directory
>>we
>> set up, and typing the location i.e.
>>\\OtherServer\Backups
>> results in an error.
>> All accounts we have tried are domain accounts, and
>>they
>> have access to the directory.
>> Can anyone tell me what I'm missing ?
>> Thanks
>> Peter
>>
>>.
>>.
>>.
>.
>|||That is not true. I have been backing up all my databases
on to a backup server for ages.
Can you ping the destination server from the source
server ' It may be a firewall issues e.t.c.
One of the best practice is to set the SQL Server service
and the SQL Server agent service be run by a domain
account. Make sure you include this domain account in
the 'Administrators' group of the both servers (You will
have to stop and restart the services). When you create
the maintenence plan, make the jobs owner this domain
account. But the most important thing is that make sure
you have connection between the two servers.
>--Original Message--
>Thanks for all your help, it seems that you cannot do it
>from the database maintence plan.
>Sue the error was 'Directory was not found', and yes the
>directory was there and we do have access rights to the
>directory. It seems that the database maintenance plan
>will only allow you to save to the server SQL is running
>on.
>Peter
>
>>--Original Message--
>>You never did say what exactly the error is that you are
>>getting and that makes a difference but...backing up
>across
>>the network isn't necessarily the best idea. You may
want
>to
>>backup to a local drive and then copy the backup to
>whatever
>>location you want to keep these on the network.
>>-Sue
>>On Tue, 20 Apr 2004 09:16:53 -0700, "Peter"
>><anonymous@.discussions.microsoft.com> wrote:
>>Thanks it does.
>>It is not a problem with the account, but seems to be a
>>problem with the Database Maintenance Plan.
>>thanks
>>Peter
>>
>>--Original Message--
>>Check that if the account that runs the SQL Server
>>Services has access to the computer you are trying to
>>backup to..........
>>
>>--Original Message--
>>Thanks for your reply.
>>However we are trying to do this from the Database
>>Maintenance Plan, any pointers ?
>>Thanks
>>Peter
>>
>>--Original Message--
>>Give this a try in Query Analyser :-
>>BACKUP DATABASE pubs to DISK='\\server01
>>\share\backupdir\backup.dmp'
>>--
>>HTH
>>Ryan Waight, MCDBA, MCSE
>>"Peter" <anonymous@.discussions.microsoft.com> wrote
>in
>>message
>>news:196c01c426ec$5fa7b420$a601280a@.phx.gbl...
>>> Dear All,
>>>
>>> We are running Standard Edition 2000 SP3a on a
2003
>>Server.
>>>
>>> We would like to backup onto the disk of a
>different
>>2003
>>> Server.
>>>
>>> However under the "Use this directory" of the
>Database
>>> Maintenance Plan, it does not give the share
>>directory
>>we
>>> set up, and typing the location i.e.
>>\\OtherServer\Backups
>>> results in an error.
>>>
>>> All accounts we have tried are domain accounts,
and
>>they
>>> have access to the directory.
>>>
>>> Can anyone tell me what I'm missing ?
>>>
>>> Thanks
>>> Peter
>>
>>.
>>.
>>.
>>
>>.
>.
>|||It will allow you to backup to a network directory when
using a unc path. In terms of who has access rights, it's
the SQL Server service account that needs rights. The
service account needs to be a domain account with
appropriate permissions to the other server, directory.
-Sue
On Wed, 21 Apr 2004 01:15:19 -0700, "Peter"
<anonymous@.discussions.microsoft.com> wrote:
>Thanks for all your help, it seems that you cannot do it
>from the database maintence plan.
>Sue the error was 'Directory was not found', and yes the
>directory was there and we do have access rights to the
>directory. It seems that the database maintenance plan
>will only allow you to save to the server SQL is running
>on.
>Peter
>
>>--Original Message--
>>You never did say what exactly the error is that you are
>>getting and that makes a difference but...backing up
>across
>>the network isn't necessarily the best idea. You may want
>to
>>backup to a local drive and then copy the backup to
>whatever
>>location you want to keep these on the network.
>>-Sue
>>On Tue, 20 Apr 2004 09:16:53 -0700, "Peter"
>><anonymous@.discussions.microsoft.com> wrote:
>>Thanks it does.
>>It is not a problem with the account, but seems to be a
>>problem with the Database Maintenance Plan.
>>thanks
>>Peter
>>
>>--Original Message--
>>Check that if the account that runs the SQL Server
>>Services has access to the computer you are trying to
>>backup to..........
>>
>>--Original Message--
>>Thanks for your reply.
>>However we are trying to do this from the Database
>>Maintenance Plan, any pointers ?
>>Thanks
>>Peter
>>
>>--Original Message--
>>Give this a try in Query Analyser :-
>>BACKUP DATABASE pubs to DISK='\\server01
>>\share\backupdir\backup.dmp'
>>--
>>HTH
>>Ryan Waight, MCDBA, MCSE
>>"Peter" <anonymous@.discussions.microsoft.com> wrote
>in
>>message
>>news:196c01c426ec$5fa7b420$a601280a@.phx.gbl...
>>> Dear All,
>>>
>>> We are running Standard Edition 2000 SP3a on a 2003
>>Server.
>>>
>>> We would like to backup onto the disk of a
>different
>>2003
>>> Server.
>>>
>>> However under the "Use this directory" of the
>Database
>>> Maintenance Plan, it does not give the share
>>directory
>>we
>>> set up, and typing the location i.e.
>>\\OtherServer\Backups
>>> results in an error.
>>>
>>> All accounts we have tried are domain accounts, and
>>they
>>> have access to the directory.
>>>
>>> Can anyone tell me what I'm missing ?
>>>
>>> Thanks
>>> Peter
>>
>>.
>>.
>>.
>>
>>.
