Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    7

    Unanswered: Backups over a network

    I am using the following syntax in sql 2000 in order to transfer the backup across the network to a backup machine:

    xp_cmdshell N'copy /Y c:\mssql7\backup\bill_backup.bak \\Backup\backups\Bill\Backup'

    The problem I am experiencing is that when I run this script, I get the response:

    Access is denied.
    0 file(s) copied

    Can anyone tell me what I am doing wrong?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    [dooooh]
    [s]
    Yea, your service account doesn't have rights to the box..

    besides, backing up across the network can't be a good idea..

    why not dump it locally and then move it?
    [/s]
    [/dooooh]

    Still, don't you think it's a security thing?
    Last edited by Brett Kaiser; 11-25-03 at 16:40.
    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.

  3. #3
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Originally posted by Brett Kaiser
    Yea, your service account doesn't have rights to the box..

    besides, backing up across the network can't be a good idea..

    why not dump it locally and then move it?
    he is backing up locally and then trying to copy it over the network .. Brett

    read the post again

    xp_cmdshell N'copy /Y c:\mssql7\backup\bill_backup.bak \\Backup\backups\Bill\Backup'
    Get yourself a copy of the The Holy Book

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

  4. #4
    Join Date
    Nov 2003
    Posts
    7
    Ok, ive given up and having sql do the move for me. Not exactly sure whats causing the problem, but I have worked around it. I have just written a bat file that copies over a mapped drive that is run thru the schedule tasks interface. Not as clean as I would like, but it works.

    Thanks again guys

Posting Permissions

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