Sql Server Programming :: backup to network


	backup to network I am using sql server 2000 with the default instance (if that matters), and I would like to save backups to a network drive however I can't see anything more than the local disks from Enterprise Manager. How can I get around this? thanks Andre First backup to local disk and then copy resulting files to network drive HTH Alex "Andre Gibson" <AndreGib@discussions.microsoft.com> wrote in message news:0433B72C-BE8B-4F03-AA35-A8A204730A65@microsoft.com... - Hide quoted text - >I am using sql server 2000 with the default instance (if that matters), and >I > would like to save backups to a network drive however I can't see anything > more than the local disks from Enterprise Manager. How can I get around > this? > thanks > Andre HI On the server machine create a mapped drive pointing to your backup folder -- Vt Knowledge is power;Share it http://oneplace4sql.blogspot.com "Andre Gibson" <AndreGib@discussions.microsoft.com> wrote in message news:0433B72C-BE8B-4F03-AA35-A8A204730A65@microsoft.com... - Hide quoted text - >I am using sql server 2000 with the default instance (if that matters), and >I > would like to save backups to a network drive however I can't see anything > more than the local disks from Enterprise Manager. How can I get around > this? > thanks > Andre Use UNC Naming (i.e. \\server\share\...) NOTE: You will be unable to do this unless the service logins for sql server (and the agent if automated jobs) have permissions to the remote share. -- TheSQLGuru President Indicium Resources, Inc. "Andre Gibson" <AndreGib@discussions.microsoft.com> wrote in message news:0433B72C-BE8B-4F03-AA35-A8A204730A65@microsoft.com... - Hide quoted text - >I am using sql server 2000 with the default instance (if that matters), and >I > would like to save backups to a network drive however I can't see anything > more than the local disks from Enterprise Manager. How can I get around > this? > thanks > Andre