SQLServerCentral / SQL Server 2005 / SQL Server 2005 Strategies / Back up to other server .. not in path / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 09:45:08 GMT20RE: Back up to other server .. not in pathhttp://www.sqlservercentral.com/Forums/Topic1380375-361-1.aspxDOH! Really (as in silly me)Thanks!Fri, 02 Nov 2012 18:04:17 GMTbritinusaRE: Back up to other server .. not in pathhttp://www.sqlservercentral.com/Forums/Topic1380375-361-1.aspxYou need to ensure that the account running the SQL server service has access to write to the unc pathFri, 02 Nov 2012 11:10:19 GMTanthony.greenRE: Back up to other server .. not in pathhttp://www.sqlservercentral.com/Forums/Topic1380375-361-1.aspxThanks 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. Fri, 02 Nov 2012 10:10:20 GMTbritinusaRE: Back up to other server .. not in pathhttp://www.sqlservercentral.com/Forums/Topic1380375-361-1.aspxNote 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.Fri, 02 Nov 2012 09:37:14 GMTSteve Jones - SSC EditorRE: Back up to other server .. not in pathhttp://www.sqlservercentral.com/Forums/Topic1380375-361-1.aspxYou will need to manually create the backup command passing in the UNC pathSomething like[code="sql"]BACKUP DATABASE database1 TO DISK = '\\SERVER\share\database1.bak'[/code]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.Fri, 02 Nov 2012 07:52:08 GMTanthony.greenBack up to other server .. not in pathhttp://www.sqlservercentral.com/Forums/Topic1380375-361-1.aspxWe'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? RobertFri, 02 Nov 2012 07:48:53 GMTbritinusa