How to backup database on the other servers in the LANS.I would suggest MSX operations
make one server your MSX (multiserver administration server)
and enlist all the others as targets
create enough jobs on the master server to perform all of the backups as neccessary
(dont forget to backup master model and msdb every night)
schedule the jobs accordingly
and then convert the jobs to multiserver jobs and post them to the other servers
Books Online Multiserver Administration|||I use the next to backup database to the other server
use master
exec sp_addumpdevice 'disk','networkdevice','\\192.168.0.1\share\aa.ext '
backup database verdata to networkdevice
the problem is 'can't open the deviece'|||map a network drive to the path
for example
open command prompt --> net use x: \\192.168.0.1\share
then try your statement as such
exec sp_addumpdevice 'disk','networkdevice','X:\aa.ext'|||Originally posted by xiangmeihong
I use the next to backup database to the other server
use master
exec sp_addumpdevice 'disk','networkdevice','\\192.168.0.1\share\aa.ext '
backup database verdata to networkdevice
the problem is 'can't open the deviece'
Does it fail on step 1 or step 2?
Whatever account you are running this command under needs to have access to this share: \\192.168.0.1\share\|||I'd suggest each serever perform their own backups...and if you want to centralize the dumps, copy them when it's done...
But that's just me...
MOO|||Originally posted by xiangmeihong
I use the next to backup database to the other server
use master
exec sp_addumpdevice 'disk','networkdevice','\\192.168.0.1\share\aa.ext '
backup database verdata to networkdevice
the problem is 'can't open the deviece' Is the service running under a domain account? Also, this account needs to have enough privieges on the target share.|||Originally posted by derrickleggett
Does it fail on step 1 or step 2?
Whatever account you are running this command under needs to have access to this share: \\192.168.0.1\share\
fail in step 2
thanks|||Try this:
BACKUP DATABASE verdata
TO DISK = '\\192.168.0.1\share\aa.bak'
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment