Back up to other server .. not in path

  • We're in the process of migrating SQL 2000 to SQL 2005.

    We're going to use the existing "box" that runs SQL 2000 as a temporary external back up device.

    Slowly we are moving the data and log files over ...

    Under Windows 7, we are able to easily copy files from one server to the other ... from SQL2000 to SQL2005 boxes. Thus the new server can "see" and copy from the old box to the new.

    But when we want to start backing up (already) to the old box ... SQL2005 is not including in the pull down list (browse) anything but the local server.

    No network option.

    We right click on the given database, in the Destination list at bottom, we see a local folder; we click Add. then click on the elipses; and only see the local server.

    What am I doing wrong?

    Robert

  • You will need to manually create the backup command passing in the UNC path

    Something like

    BACKUP DATABASE database1 TO DISK = '\\SERVER\share\database1.bak'

    You can manually type in the UNC path to the backup GUI, but the backup GUI cannot see anything other than the local drives of the SQL server.

  • Note that the service account running on the new server needs rights to get to the SQL 2000 server. Along with that, use Anthony's advice.

  • Thanks for the reply ...

    Tried manually entering the UNC. While windows explorer copies fine to the backup server, sql 2005 fails with an error ...

    Error 5: Access denied.

  • You need to ensure that the account running the SQL server service has access to write to the unc path

  • DOH! Really (as in silly me)

    Thanks!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply