Re: Backing up to a different server
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 04/21/04
- Next message: Emma: "Log activities"
- Previous message: Jo Segers: "Re: Salvaging Data from the Transaction Logs"
- In reply to: Peter: "Re: Backing up to a different server"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Apr 2004 08:56:03 -0600
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
>>>>>>
>>>>>>
>>>>>>.
>>>>>>
>>>>>.
>>>>>
>>>>.
>>>>
>>
>>.
>>
- Next message: Emma: "Log activities"
- Previous message: Jo Segers: "Re: Salvaging Data from the Transaction Logs"
- In reply to: Peter: "Re: Backing up to a different server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
