Backup Sql 2000 to a network drive

  • Hi Guys,

    Please I need some help trying to backup my SQL 2000 to a network Drive.

    Please could anybody give me a little help how can I do it by EM?

    Thank you.

  • Here are some suggestions:

    CLICK

  • You can do that, you just can't browse to the location.

    In the file location type in the UNC Pathname and the filename you want to backup to (i.e. \\Server\share\SQLbackup.bak)

    Where ever you backup to make sure that the user you are logged in as has the appropriate level of rights to write to that share. Likewise, if you were to schedule a job the account that runs the SQL Agent must have the appropriate level of rights to that shared in order to place a file there.

    Regards, Irish 

Viewing 3 posts - 1 through 2 (of 2 total)

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