Re: Backup across the Network
From: Aju (ajuonline_at_yahoo.com)
Date: 06/03/04
- Next message: Sorin Sandu: "Can't login with windows user"
- Previous message: Peter Yeoh: "Re: restoring incremental backup fails"
- In reply to: Hari Prasad: "Re: Backup across the Network"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 3 Jun 2004 09:56:44 +0530
Hi ,
Just to add this you can map the remote share on you database server .
The mapped drive can be used to backup on .
Thanks
Ajay
"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:ObmCswLSEHA.904@TK2MSFTNGP12.phx.gbl...
> Hi,
>
>
> Can I do a database backup onto a file on another server?
>
> Yes , follow the below steps. Enterprise manager will only show the local
> disks.
>
> There are Few Pre requisites to do backup remotely;
>
>
> 1. You Should start SQL server using Domain user who got access to remote
> machine Share
> 2. Should have share in the remote machine
> 3. If you need to schedule this as a job then SQL Agent should use the
same
> Domain user in which SQL server was started
> 4. Restart the services
>
> Now you can execute the Backup script with UNC path
>
> BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak'
with
> init
>
> Note:
>
> Backup to remote machine will not work if you start SQL server using Local
> system account
>
> Thanks
> Hari
> MCDBA
>
> "dschrier" <anonymous@discussions.microsoft.com> wrote in message
> news:72E05DAF-E254-4B13-926B-D183E9E95EAD@microsoft.com...
> > We are using SQL2000
> >
> > Can I do a database backup onto a file on another server?
> > In Enterprise Manager, I can't seem to specify a device on another
server.
> > Thanks for any help.
>
>
- Next message: Sorin Sandu: "Can't login with windows user"
- Previous message: Peter Yeoh: "Re: restoring incremental backup fails"
- In reply to: Hari Prasad: "Re: Backup across the Network"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
