Re: Backup into another machine.

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
>
>


.

Relevant Pages

  • Re: Backup into another machine.
    ... but there are Few Pre requisites to do backup ... You Should start SQL server using Domain user who got access to remote ... > Backup to remote machine will not work if you start SQL server using Local ...
    (microsoft.public.sqlserver.clients)
  • Re: Backing up database on a network machine
    ... You cant see the network drives. ... You Should start SQL server using Domain user who got access to remote ... Now you can execute the Backup script with UNC path ...
    (microsoft.public.sqlserver.msde)
  • Re: automatic sql server backup to networked machine
    ... There are Few Pre requisites to do backup remotely; ... You Should start SQL server using Domain user who got access to remote ... If you need to schedule this as a job then SQL Agent should use the same ...
    (microsoft.public.sqlserver.connect)
  • Re: automatic sql server backup to networked machine
    ... There are Few Pre requisites to do backup remotely; ... You Should start SQL server using Domain user who got access to remote ... If you need to schedule this as a job then SQL Agent should use the same ...
    (microsoft.public.sqlserver.server)
  • Re: automatic sql server backup to networked machine
    ... There are Few Pre requisites to do backup remotely; ... You Should start SQL server using Domain user who got access to remote ... If you need to schedule this as a job then SQL Agent should use the same ...
    (microsoft.public.sqlserver.server)
Loading