Re: Cannot restore database from a remote server

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 12/01/04 

Date: Wed, 1 Dec 2004 01:01:08 +0100

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.
>
>

Relevant Pages

  • Re: Cant see mapped drives
    ... You cant see the mapped drives in Enterprise manager. ... Restore database command from Query Analyzer. ... > and remote machine admin grp. ...
    (microsoft.public.sqlserver.server)
  • Re: Cannot restore database from a remote server
    ... SQL Enterprise Manager does not look at mapped drives. ... You need to use T-SQL code (RESTORE DATABASE) and supply the file name using ...
    (microsoft.public.sqlserver.setup)
  • Re: Cannot restore database from a remote server
    ... SQL Enterprise Manager does not look at mapped drives. ... You need to use T-SQL code (RESTORE DATABASE) and supply the file name using ...
    (microsoft.public.sqlserver.server)
  • Re: Prob. to Restore Database
    ... > If I restore my old db Using Enterpise Manager (with ... > 10, RECOVERY, REPLACE ... >>Perhaps the backup is a file or filegroup backup? ... >>> But this option is supported from RESTORE DATABASE ...
    (microsoft.public.sqlserver.server)
  • Re: Problem restoring a database from a .bak file
    ... The first method from the Enterprise Manager kept giving me errors, but I used T-SQL looked in the books online and with MOVE TO clause after the RESTORE... ... > file name (.BAK file) ...
    (microsoft.public.sqlserver.server)