Restoration From Network Drive

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Tommy.Vincent@gmail.com
    #1

    Restoration From Network Drive

    Hi,

    When i use to work on Windows 2000 advance server and Sql 2000
    I was able to do network restoration by using a mapped drive where my
    backup use to be lying.What i did was I assigned administrator rights
    to my login and in Services (mssqlserver)i added my login.
    Then I was able to access any mapped drive from my network in Sql
    server 2000.


    Now i have switched my OS to Windows Server 2003.
    What I want to know is , is their any other setting that has to done
    for network restoration , because after following above steps then to I
    am not able to access mapped drive in SQL SERVER 2000.

    So can anyone help me to know what setting should i do in Windows 2003
    server or in SQL Server 2000 to do a network restoration of database.

    Thanks in advance
    TV

    Tags: None
    • Dan Guzman
      #2
      Re: Restoration From Network Drive

      > So can anyone help me to know what setting should i do in Windows 2003[color=blue]
      > server or in SQL Server 2000 to do a network restoration of database.[/color]

      Ensure the SQL Server service is running under a domain account with
      permissions to the share. Use a UNC path rather than a mapped network
      drive. For example:

      RESTORE DATABASE MyDatabase
      FROM '\\REMOTESERVER \BackupShare\My Database.bak'
      WITH STATS=10

      --
      Hope this helps.

      Dan Guzman
      SQL Server MVP

      <Tommy.Vincent@ gmail.com> wrote in message
      news:1120205182 .946293.108160@ g43g2000cwa.goo glegroups.com.. .[color=blue]
      > Hi,
      >
      > When i use to work on Windows 2000 advance server and Sql 2000
      > I was able to do network restoration by using a mapped drive where my
      > backup use to be lying.What i did was I assigned administrator rights
      > to my login and in Services (mssqlserver)i added my login.
      > Then I was able to access any mapped drive from my network in Sql
      > server 2000.
      >
      >
      > Now i have switched my OS to Windows Server 2003.
      > What I want to know is , is their any other setting that has to done
      > for network restoration , because after following above steps then to I
      > am not able to access mapped drive in SQL SERVER 2000.
      >
      > So can anyone help me to know what setting should i do in Windows 2003
      > server or in SQL Server 2000 to do a network restoration of database.
      >
      > Thanks in advance
      > TV
      >[/color]


        Comment

        Previous template Next
        Working...