Results 1 to 11 of 11
  1. #1
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2

    Unanswered: Backup on a Network Share

    Hello,

    I am trying to backup a database with a command like:

    BACKUP DATABASE my DataBase TO DISK = '\\bkSystem\bkDisk\Backup1.bak'

    but I get the error 'Cannot open backup device '\\bkSystem\bkDisk\Backup1.bak'. Device error or device off-line.
    The bkDisk folder is shared, with Everyone full-control access (it's a test environment)

    MS SQL 2000.

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    map a drive. use the mapped drive instead of the unc.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Thanks for your reply.
    Unfortunately I don't have physical access to the server machine (but only to the SQL Server) so I am not able to map a drive.

  4. #4
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    ok. then contact someone who does.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  5. #5
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    ok. sorry I wasn't more clear.
    I am in a test environment with an application which needs to create a database backup on a client folder. Because I don't know how will be the production environment, I don't want to depend on some server characteristics, so I made the assumption that I don't have access to it (and at some customers I really don't).
    That's why I think the mapping solution it is not a suitable one.

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The problem is that either the path given is incorrect, or the SQL Server service account has no rights to write to that share. From the error message, I would check the path first.

  7. #7
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    The path is correct.
    In the meantime, this link:
    http://www.fmsinc.com/freE/NewTips/SQL/SQLtip9.asp
    clarified the thinks for me. Now I have to see what I will do.

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What?

    No room on the local drive?

    Unless I'm jacked up, I always dump locally

    you can always move it

    How big is the db?
    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.

  9. #9
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    You should be happy about SQL 2008, then. They are introducing native compression of backups. It will probably run the CPU up a bit for the duration of the backup, but it saved me about 60% in my first test.

  10. #10
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I believe MCrowley backs up across the network so on that basis alone it is worthy of consideration.

    The link you posted is rather one sided however. We backed up to a SAN for some time. The problem (especially when the backups are measued in TB so the window of disopportunity is larger) is that a slight network blip b0rks the whole thing. I still prefer backing up locally and copying across. IME a network connection is more fragile than a disc. Another advantage of backing up locally and copying across is, once complete, you have two copies. Further, when it comes to restore (assuming you want to restore the last backup) you already have it locally. We only keep the one backup locally - we have a few days on the SAN, the remainder on tape.

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  11. #11
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Yes, a locally backup seems to be the obvious solution. However, somebody here thought that a network backup is a better solution - so I started to dig up.
    Anyway, thanks for your advises.

Posting Permissions

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