Re: Backup into another machine.
- From: "Joh" <joh@xxxxxxxxxxxx>
- Date: Tue, 17 May 2005 14:11:56 -0400
Thanks Hari.
"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> wrote in message
news:u6p7KtwWFHA.2700@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
>
> Command looks good, but 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
> SQL Server MVP
>
>
> "Joh" <joh@xxxxxxxxxxxx> wrote in message
> news:%23bZ55ewWFHA.2520@xxxxxxxxxxxxxxxxxxxxxxx
> >I am trying to take the backup into another machine which is on the
network
> > but failed to do so....
> >
> > Like backup database Health to disk =
> > '\\nSys0120\Backup\Health\bkHealth05172005'
> >
> > is the above command is okie ?
> >
> > Thanks
> >
> >
>
>
.
- References:
- Backup into another machine.
- From: Joh
- Re: Backup into another machine.
- From: Hari Prasad
- Backup into another machine.
- Prev by Date: Re: Expert help !
- Next by Date: Re: Backup into another machine.
- Previous by thread: Re: Backup into another machine.
- Next by thread: Re: Backup into another machine.
- Index(es):
Relevant Pages
|
