Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    19

    Unanswered: Backup database over network not working.

    The database server is on computer P4.
    Computer P3 has a shared folder with full access.
    Computer P5 on which I have my Backup Device and will execute the Backup Database Command using Query Analyzer.

    On P5 I created the Backup Device:

    USE master
    EXEC sp_addumpdevice 'disk', 'myDevice',
    '\\P3\temp\test.bak'

    Then I executed the following on P5 Query Analyzer:

    Backup Database myDatabase TO myDevice


    But I get this error:

    Server: Msg 3201, Level 16, State 1, Line 1
    Cannot open backup device 'myDevice'. Device error or device off-line. See the SQL Server error log for more details.
    Server: Msg 3013, Level 16, State 1, Line 1
    BACKUP DATABASE is terminating abnormally.


    Any idea? Thanks and regards.

  2. #2
    Join Date
    Mar 2004
    Posts
    4

    Re: Backup database over network not working.

    Originally posted by juniper
    The database server is on computer P4.
    Computer P3 has a shared folder with full access.
    Computer P5 on which I have my Backup Device and will execute the Backup Database Command using Query Analyzer.

    On P5 I created the Backup Device:

    USE master
    EXEC sp_addumpdevice 'disk', 'myDevice',
    '\\P3\temp\test.bak'

    Then I executed the following on P5 Query Analyzer:

    Backup Database myDatabase TO myDevice


    But I get this error:

    Server: Msg 3201, Level 16, State 1, Line 1
    Cannot open backup device 'myDevice'. Device error or device off-line. See the SQL Server error log for more details.
    Server: Msg 3013, Level 16, State 1, Line 1
    BACKUP DATABASE is terminating abnormally.


    Any idea? Thanks and regards.

    yeah, go into Enterprise Manager, right click on the db you are trying to backup and all tasks - bring online

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Better yet....don't dump across a network....

    It'll be much slower and be at risk for blips in the network....

    Dump local then copy....
    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.

  4. #4
    Join Date
    Nov 2003
    Posts
    19
    Hi guys, thanks for your advice. Brett, I am doing it the way you suggested. However, it would mean that the computer running the database server would have to have a folder permanently shared for my program to copy the file across the network.

    Any workaround so that I do not need to share folders? The user might inadvertently unshare the folder and would create problems.

    Thanks and regards.

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Ensure the account used to execute this task does have required privileges to access the share specified.

    If you're scheduling this task then ensure SQLAgent account used does have admin privileges or a domain account to access so.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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