Post reply

Backup a SQL database from one domain to another

  • May 29, 2008 at 11:25 am

    #186163

    Hello

    I'm trying this and I know it works in anohter compnay before

    execute master..xp_cmdshell 'net use N: \\Servername\SQLDataShare\Backups\Full\ /user:abc password'

    I'm getting The network Path cannot be found

    it's from one domain to another..

    any ideas?

    thanks

  • May 29, 2008 at 1:45 pm

    #821981

    The user must be a valid domain user on the domain attaching to AND have, at minimum, rights to read to perform net use to \\Servername\SQLDataShare\Backups\Full\ . It'll also need write rights for backing up. Just curious, is there a special reason for going across domains?

    -- You can't be late until you show up.

  • May 29, 2008 at 1:49 pm

    #821984

    ok thanks, the reason is there is no disk space in one of the domains and I can't backup it at all.

    thanks

  • May 29, 2008 at 1:54 pm

    #821988

    As long as you get backups, whatever works for you is fine. Be sure to test the validity of your backup files from time to time.

    -- You can't be late until you show up.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply