problem saving database bkf file to another PC on network

When you are selecting the destination location for the backup file, you are selecting a local directory on the computer you are at. The Backup process just passes that to SQL Server or MSDE on the Server. That path is not available on the server or you don't have rights to save there...

What you need to do is created a shared folder somewhere on the network that both your workstation and the server can recognize using the same UNC Path and have access to. Then you have to browse to the share name(\\computerName\ShareName\FolderName\FileName), not to the local drive name(C:\FolderName\FileName)

Glenn Adams Tiber Creek C> I can save a database bkf file to the same PC the database is running on,

Do you mean it has to be on a 3rd party drive because they need the exact same file name?

Glenn Adams [MVP - Retail Mgmt] wrote:

No, you can create the share on either the server, the workstation or any other system on the network - the server and the work station both need to be able to find it using the same path name.

Glenn Adams Tiber Creek C> Do you mean it has to be on a 3rd party drive because they need the exact

Just save it into your SHARED folder on your local hard drive. That way if the server crashes hard, you have it local.

OlyBikes wrote: