Backup across the Network

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.
Yes. Just type a UNC name.
Note: SQL must be running under a domain-level account with FULL CONTROL
rights to the share and underlying folders. Don't use administrative
(C$,D$, etc) shares.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"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.
|||First create a backup device that points to a network share on the other
server, than backup to that backup device.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"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.
|||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.
|||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[vbcol=seagreen]
> 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...
server.
>