Results 1 to 2 of 2

Thread: Network - Database backup

  1. 10-04-2002, 09:55 AM #1
    rnadesan
    rnadesan is offline Registered User
    Join Date
    Sep 2002
    Posts
    5

    Network - Database backup

    I tying to test my backup to a network drive but it fails.

    Please help ..thanks
    this is the script -- example from BOL:

    BACKUP DATABASE pubs
    TO DISK '\\radris\MSSQL\BACKUP\pubtest.bak'

    this is the error:

    Server: Msg 3201, Level 16, State 1, Line 1
    Cannot open backup device '\\radris\MSSQL\BACKUP\pubtest.bak'. 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.
    Reply With Quote Reply With Quote
  2. 10-04-2002, 10:24 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You should start sql services with domain account that has permission on remote location, and you didn't have drive letter in your command. Better to create share on remote server.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules