Cannot restore database from a remote server

I am unable to restore a new database from a backup located in a different
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>