Re: Backup across the Network
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 06/02/04
- Next message: Jason Roozee: "Re: Fast Way To "Insert Into" a million records?"
- Previous message: Hawk: "Connection failed"
- In reply to: dschrier: "Backup across the Network"
- Next in thread: Aju: "Re: Backup across the Network"
- Reply: Aju: "Re: Backup across the Network"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 2 Jun 2004 21:36:10 +0530
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: Jason Roozee: "Re: Fast Way To "Insert Into" a million records?"
- Previous message: Hawk: "Connection failed"
- In reply to: dschrier: "Backup across the Network"
- Next in thread: Aju: "Re: Backup across the Network"
- Reply: Aju: "Re: Backup across the Network"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
