Re: automatic sql server backup to networked machine

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/09/04 

Date: Fri, 9 Jul 2004 22:31:40 +0530

Hi,

Enterprise manager will only show the local disks not the mapped drives.

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

How to schedule
-----------------
Enterprise Manager - Management -- SQL Agent -- Jobs -- Right click and
create new job. Give a name to the Job and in Job step mention this above
backup script and schedule the job to be executed based on requirement

Thanks
Hari
MCDBA

"Dhruv" <dmalhotr2001@yahoo.com> wrote in message
news:b6d0b0b.0407090855.43690994@posting.google.com...
> Hi,
>
> I am currently backing up to my machine on my localbox of the database
> I want with enterprise manager.
>
> I would like to do an automatic backup of my database running on a
> schedule on a networked shared/remote machine?
>
> How do I do that?
>
> Thanks,
>
> :DHRUV

Relevant Pages

  • Re: Restart Services
    ... How to restart SQL Server at regular intervals? ... > After that schedule this batch using the Windows scheduler or use the AT ... > See the help of AT command by executing the below from command prompt:- ... >> Do you want to stop the services so that you can backup your databases? ...
    (microsoft.public.sqlserver.clients)
  • Re: database backup schedule not working
    ... On the schedules tab hit "New Schedule" ... You will want to backup your user databases, master, and model. ... > I'm running SQL server 2000 on a Windows Server 2003. ... > Database, selected the local disk as a backup destination, clicked on ...
    (microsoft.public.sqlserver.tools)
  • 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: Backup into another machine.
    ... but there are Few Pre requisites to do backup remotely; ... 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)