Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    10

    Question Unanswered: Database backup directory is invalid

    Hi,

    I'm using Database Maintenance Plans in Enterprise Manager and I'm trying to backup a database to a different server using a UNC (i.e. \\servername\backupdirectory).
    I have done this successfully with two SQL Servers but every time I try to set the third SQL Server to backup to a UNC I get this message:

    The complete database backup directory '\\servername\backupdirectory' is invalid.

    The only differences that I can think of is that the server is Win2000 Advanced Server and the SQL Server is Enterprise Edn, where as the two that work are Standard Edn and are on Win2000 Servers (not Advanced).

    Does anyone know why I am unable to do this on one SQL Server when I have had no trouble on the other two SQL Servers?

    Any help would be greatly appreciated

    Thanks,

    Troy

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If I had to make a guess, I'd say that the working box was using a domain login for the SQL Server service, and the non-working box was using localSystem.

    -PatP

  3. #3
    Join Date
    Apr 2004
    Posts
    10
    Not a bad guess at all

    Thanks for your help.

    Regards, Troy.

Posting Permissions

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