Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2004
    Location
    China SHANGHAI
    Posts
    7

    Unanswered: backup database on other servers

    How to backup database on the other servers in the LANS.

  2. #2
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    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

  3. #3
    Join Date
    Mar 2004
    Location
    China SHANGHAI
    Posts
    7

    can't open the device

    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'

  4. #4
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    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'

  5. #5
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734

    Re: can't open the device

    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\
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662

    Re: can't open the device

    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.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  8. #8
    Join Date
    Mar 2004
    Location
    China SHANGHAI
    Posts
    7

    Re: can't open the device

    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

  9. #9
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Try this:

    BACKUP DATABASE verdata
    TO DISK = '\\192.168.0.1\share\aa.bak'
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •